Authenticating users with Genero db

When using Genero db, you must declare users in the database with the CREATE USER command. Users can be authenticated as database users or as operating system users. With database-only users, you need to give a login and password with the USER/USING clause of the CONNECT TO instruction. With OS authenticated users, no USER/USING clause is needed and the program can also use the DATABASE instruction.

In order to create a DB user authenticated by the Operating System, use the IDENTIFIED EXTERNALLY clause in the CREATE USER command:

CREATE USER username IDENTIFIED EXTERNALLY;

The OS users will be able to connect to the database if the $ANTSHOME/Server/ants.rhosts file contains an entry to identify the OS user.

Pay attention to the user name, which can be case-sensitive according to the database configuration settings. You can check the name of the database users by querying the system tables (ANTS_ALL_USERS in 3.80).

See the Genero db documentation for more details about OS users creation.