Iliyan and SangGyu:
I am not certain this feature ever worked under Windows OS. Typically I rely on the Windows passthrough authentication and either create a local Windows user account or an Active Directory domain account depending on how my customer site is set up.
I happened to be setting up a new system and tested the surrogate user command as Iliyan did. I got the following after creating the allowed.surrogates file:
in DBACCESS:
CREATE USER SUGER WITH PASSWORD "pass123ABC!" PROPERTIES user "username";
26729: The user username is not in the /etc/informix/allowed.surrogates file
From the command line:
D:\Program Files\IBM\Informix\12.10>onmode -cache surrogates
Warning: Loading entries in the surrogates file /etc/informix/allowed.surrogates into surrogate cache
resulted in errors. Check the message log for more information.
In the IDS message log after running onmode -cache surrogates:
10:22:55 Warning: Unable to open the surrogates file /etc/informix/allowed.surrogates.
10:22:55 Warning: Loading entries from the surrogates file /etc/informix/allowed.surrogates into surrogate cache
failed. Surrogate cache does not exist.
------------------------------
Best regards,
Martin Graney
Queues Enforth Development, Inc.
Stoneham, MA 02148
------------------------------
Original Message:
Sent: Tue March 31, 2020 08:43 AM
From: iliyan iliev
Subject: Cannot create surrogate user on IDS 12.10FC14
I try to create surrogate user on IDS(on Windows). When i run CREATE USER SUGER WITH PASSWORD "pass" PROPERTIES user "username"; in dbaccess . DBAccess send me error 26729: The user username is not in the /etc/informix/allowed.surrogates file.
Where do i put this file(allowed.surrogates) in windows installation of IDS to find dbaccess and create surrogate user.
------------------------------
iliyan iliev
developer MoI-DCIS
------------------------------
#Informix