Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: ReferenceThe HCL OneDB™ Guide to SQL: Reference contains the reference information for the system catalog tables, data types, and environment variables of the HCL OneDB™ dialect of the SQL language, as implemented in HCL OneDB™. These topics also include information about the stores_demo, sales_demo, and superstore_demo databases that are included with HCL OneDB™.
System catalog tablesThe system catalog consists of tables and views that describe the structure of the database. Sometimes called the data dictionary, these table objects contain everything that the database knows about itself. Each system catalog table contains information about specific elements in the database. Each database has its own system catalog.
SYSSURROGATEAUTHThe syssurrogateauth system catalog table stores trusted user and surrogate user information.

SYSSURROGATEAUTH

The syssurrogateauth system catalog table stores trusted user and surrogate user information.

The syssurrogateauth system catalog table is populated when the GRANT SETSESSIONAUTH statement is run. Users or roles specified in the TO clause are added to trusteduser column. Users specified in the ON clause are added to surrogateuser column.

For example, consider the following statement:

GRANT SETSESSIONAUTH ON bill, john TO mary, peter;

Entries in the syssurrogateauth table are created as follows:

trusteduser    surrogateuser

mary           bill
mary           john
peter          bill
peter          john

The syssurrogateauth table has the following columns.

Table 1. SYSSURROGATEAUTH table column descriptions
Column	Type	Explanation
trusteduser	CHAR(32)	Trusted user name or role.
surrogateuser	CHAR(32)	Surrogate user name.