Database authorization and table names

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 run-time property vgj.jdbc.default.userid

  • When you invoke the system function sysLib.connect or sysLib.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.

Related concepts


Dynamic SQL
Java run-time properties
SQL support

Related reference
Java run-time properties (details)
SQL record part in EGL source format
sysLib.connect
sysLib.connectionService