Create none OS user Informix 14
Alexander Ivanov moving from Informix 9 to 14 wanted a database user without an OS account, but CREATE USER failed on USERMAPPING and then said the user was not mapped to any properties. Mike Walker advised an allowed.surrogates file owned by root, naming a real OS user other than informix, and was unsure about the error. Unresolved.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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 ------------------------------
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 ------------------------------
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 ------------------------------
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. ------------------------------ Mike Walker xDB Systems, Inc www.xdbsystems.com ------------------------------