SQL adaptation guide For Genero db 3.6x, 3.8x / Installation (Runtime Configuration) |
Genero db version | Shared library environment setting |
---|---|
Version 3.81 and lower | UNIX: Add $ANTSHOME/antsodbc (or $ANTSHOME/antsodbc/64 for 64 bit) to LD_LIBRARY_PATH (or its equivalent). Windows: Add %ANTSHOME%\antsodbc to PATH. |
$ antscmd -d dns-name -u appadmin -p password
For more details about the SQL features affected by the COMPATIBILITY_MODE parameter, see the Genero db Migration Guide.
dbi.database.dbname.ads.compatibility.check = "none"
With Genero db, a schema is created when creating a user. If the APPADMIN user creates the tables, the schema for application tables will be "APPADMIN".
mydb> CREATE USER username IDENTIFIED BY password DEFAULT SCHEMA appadmin;
dbi.database.dbname.ads.schema = "name"
Here <dbname> identifies the database name used in the BDL program ( DATABASE dbname ) and <name> is the schema name to be used.
mydb> 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.
See the Genero db documentation for more details about OS users creation.
mydb> GRANT SELECT, INSERT, UPDATE, DELETE ON tablename TO username;
mydb> GRANT SELECT, INSERT, UPDATE, DELETE ON tablename TO PUBLIC;
If the database has stored procedures, you must also grant execute permission to application users:
mydb> GRANT EXECUTE ON procname TO username;
dbi.database.dbname.ads.driver.mode = { "3.61" | "3.80" | "3.81" }