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?

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.

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.