An authorization ID is a character string that is passed to the database
manager when a connection is established between the database manager and
a program, whether the program prepares another program or allows end-user
access to SQL tables. The character string is the user identifier that is
required to check the database-access authorization held by the preparer or
end user.
The source of the authorization ID depends on the system where database
access occurs.
The situation for EGL-generated Java™ programs is as follows:
- The authorization ID is one obtained by the database manager when a connection
was established between the database manager and the program:
- In relation to the default database, the authorization ID is the value
specified for the Java runtime property vgj.jdbc.default.userid
- When you invoke the system function sysLib.connect or VGLib.connectionService,
the authorization ID is the value specified for the userID parameter
The authorization ID may be used when you specify a table name. In that
case, you can specify a table-name qualifier, in accordance with this syntax:
tableOwner.myTable
- tableOwner
- A qualifier that is known to the database manager and that is necessary
to identify the table. The qualifier at table creation is the authorization
ID of the person who created the table.
- myTable
- The table name.
For more information on authorization IDs, consult your database manager
documentation.