Database connections / Database user authentication |
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.