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.
SYSXTDTYPEAUTHThe sysxtdtypeauth system catalog table identifies the privileges on each UDT (user-defined data type).

SYSXTDTYPEAUTH

The sysxtdtypeauth system catalog table identifies the privileges on each UDT (user-defined data type).

The sysxtdtypeauth table contains one row for each set of privileges granted and has the following columns:


Column	Type	Explanation
grantor	VARCHAR(32)	Name of grantor of privilege
grantee	VARCHAR(32)	Name of grantee of privilege
type	INTEGER	Code identifying the UDT
auth	CHAR(2)	Code identifying privileges on the UDT: n or N = Under privilege u or U = Usage privilege

If the privilege code in the auth column is upper case (for example, 'U' for usage), a user who has this privilege can also grant it to others. If the code is in lower case, a user who has the privilege cannot grant it to others.

A composite index on type, grantor, and grantee allows only unique values. A composite index on the type and grantee columns allows duplicate values.