I think you can turn on USERMAPPING then create database user rather than from AD.

https://help.hcl-software.com/hclinformix/1410/adr/ids_adr_1101.html

Hello ke chen, many thanks for the answer. 

I understand, that I have to do the setting in onconfig on windows side? Is it then necessary to create a local user "test" on the windows server or will it bypased from the Linux Server?

I have to do following statements in the database for the user test. That is clear.  CREATE USER and ALTER USER to register values in appropriate system tables of the SYSUSER database:

I think you can turn on USERMAPPING then create database user rather than from AD.

https://help.hcl-software.com/hclinformix/1410/adr/ids_adr_1101.html

You do not need to create OS level user test at either windows or linux.

On your windows DBMS, you run:

1. onmode -wf USERMAPPING=BASIC 

2. create /etc/informix/allowed.surrogates file, as example of:

#Surrogate IDs

#

users:user1

group:18

(user1 is the existing OS user on windows DBMS server).

3.  onmode -cache surrogates

4.  dbaccess

CREATE USER test WITH PASSWORD "test" PROPERTIES user "user1";

5. dbaccess

grant connect to test;

The purpose of using usermapping is to skip creating OS user test, it can be mapped to another existing OS user on Windows.

Have a try, good luck.

Hello ke chen, many thanks for the answer. 

I understand, that I have to do the setting in onconfig on windows side? Is it then necessary to create a local user "test" on the windows server or will it bypased from the Linux Server?

I have to do following statements in the database for the user test. That is clear.  CREATE USER and ALTER USER to register values in appropriate system tables of the SYSUSER database:

I think you can turn on USERMAPPING then create database user rather than from AD.

https://help.hcl-software.com/hclinformix/1410/adr/ids_adr_1101.html

Hello ke chen,

many thanks for your help. Now my last question. What does the "group:18" in the file "allowed,surrogates" mean? is this a special informix group? or a group in Linux?

Unfortunately I have no glue.

You do not need to create OS level user test at either windows or linux.

On your windows DBMS, you run:

1. onmode -wf USERMAPPING=BASIC 

2. create /etc/informix/allowed.surrogates file, as example of:

#Surrogate IDs

#

users:user1

group:18

(user1 is the existing OS user on windows DBMS server).

3.  onmode -cache surrogates

4.  dbaccess

CREATE USER test WITH PASSWORD "test" PROPERTIES user "user1";

5. dbaccess

grant connect to test;

The purpose of using usermapping is to skip creating OS user test, it can be mapped to another existing OS user on Windows.

Have a try, good luck.

Hello ke chen, many thanks for the answer. 

I understand, that I have to do the setting in onconfig on windows side? Is it then necessary to create a local user "test" on the windows server or will it bypased from the Linux Server?

I have to do following statements in the database for the user test. That is clear.  CREATE USER and ALTER USER to register values in appropriate system tables of the SYSUSER database:

I think you can turn on USERMAPPING then create database user rather than from AD.

https://help.hcl-software.com/hclinformix/1410/adr/ids_adr_1101.html

group id 18 is the group id of real os user user1.

on windows, I wonder you might be able to assign a random number in allowed.surrogates.

Have a try. 

You might need to try a few workarounds on windows.

Hello ke chen,

many thanks for your help. Now my last question. What does the "group:18" in the file "allowed,surrogates" mean? is this a special informix group? or a group in Linux?

Unfortunately I have no glue.

You do not need to create OS level user test at either windows or linux.

On your windows DBMS, you run:

1. onmode -wf USERMAPPING=BASIC 

2. create /etc/informix/allowed.surrogates file, as example of:

#Surrogate IDs

#

users:user1

group:18

(user1 is the existing OS user on windows DBMS server).

3.  onmode -cache surrogates

4.  dbaccess

CREATE USER test WITH PASSWORD "test" PROPERTIES user "user1";

5. dbaccess

grant connect to test;

The purpose of using usermapping is to skip creating OS user test, it can be mapped to another existing OS user on Windows.

Have a try, good luck.

Hello ke chen, many thanks for the answer. 

I understand, that I have to do the setting in onconfig on windows side? Is it then necessary to create a local user "test" on the windows server or will it bypased from the Linux Server?

I have to do following statements in the database for the user test. That is clear.  CREATE USER and ALTER USER to register values in appropriate system tables of the SYSUSER database:

I think you can turn on USERMAPPING then create database user rather than from AD.

https://help.hcl-software.com/hclinformix/1410/adr/ids_adr_1101.html