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.
SYSSECPOLICIES

SYSSECPOLICIES

The syssecpolicies system catalog table records security policies It has these columns.


Column	Type	Explanation
secpolicyname	VARCHAR(128)	Security policy name
secpolicyid	SERIAL	Security policy ID
numcomps	SMALLINT	Number of security label components in the security policy
comptypelist	CHAR(16)	An ordered list of the type of each component in the policy. A = array S = set T = tree – = Beyond NUMCOMPS
overrideseclabel	CHAR(1)	Indicates the behavior when a user's security label and exemption credentials do not allow them to insert or update a data row with the security that is label provided on the INSERT or UPDATE SQL statement. Y: The security label provided is ignored and replaced by the user's security label for write access. N: Return an error when not authorized to write a security label.