You will need the allowed.surrogates file, but I would suggest another OS user other than "informix" - maybe some application user.
I'm not sure about that error, but you may need to create a default user first. I am not sure about that.
Original Message:
Sent: Wed September 13, 2023 09:23 AM
From: Alexander Ivanov
Subject: Create none OS user Informix 14
At this point I haven't created a resolved.surrogates file because I don't understand the Informix mapping logic. Do I need to write information about the real OS user "informix" in the allowed.surrogates file?
When I tried create user i have error "SQL Error [IX000]: User (miro5) cannot be created because the user is not mapped to any properties."
------------------------------
Alexander Ivanov
Original Message:
Sent: Wed September 13, 2023 09:00 AM
From: Mike Walker
Subject: Create none OS user Informix 14
You are on the right track...
Can you share the exact error that you got when you set the USERMAPPING?
Have you created the file /etc/informix/allowed.surrogates? This needs to contain a "real" OS user. Also this file must be owned by root, and only be writeable by the root user, and not have any execute permissions.
------------------------------
Mike Walker
xDB Systems, Inc
www.xdbsystems.com
Original Message:
Sent: Wed September 13, 2023 08:39 AM
From: Alexander Ivanov
Subject: Create none OS user Informix 14
Hello. I'm moving from 9 to 14 Informix.Now I'm trying to create a user and give him the right to select from the database.In Informix 9, there is an OS user in the Informix-admin group.I don't want to create an OS user.I tried the CREATE USER statement and got an error about the USERMAPPING parameter.After I set the USERMAPPING option, an error occurred that I need to create a mapping before creating the user.Am I on the right track, or is it better to create a user in the OS?
------------------------------
Alexander Ivanov
------------------------------