2.4 Setting a referencing privilege for data dictionary tables

Executor: HiRDB administrator

To enhance system security, you can set a reference privilege for data dictionary tables in order to restrict access to the data dictionary tables. You set the reference privilege for data dictionary tables by specifying limited in the following utility control statements:

Table 2-4 shows the relationship between the dicinf operand value and the data dictionary tables that can be referenced.

Table 2-4 Relationship between the dicinf operand value and the data dictionary tables that can be referenced

Data dictionary tabledicinf operand value
limitedunlimited
DBA privilege holdersAuditorGeneral users
SQL_PHYSICAL_FILESAllAllTable information about HiRDB files that comprise RDAREAs for which the general user has usage privileges.All
SQL_RDAREASAllAllTable information about RDAREAs for which the general user has usage privileges.All
SQL_TABLESAll1All1Table information about tables for which the general user has access privileges.All
SQL_COLUMNSAll1All1Table information about columns in tables for which the general user has access privileges.All
SQL_INDEXESAll1All1Table information about indexes for tables for which the general user has access privileges.All
SQL_USERSAllAllNoneNone
SQL_RDAREA_PRIVILEGESAllAllTable information about RDAREAs for which the general user has access privileges.All
SQL_TABLE_PRIVILEGESAll1All1Table information about tables for which the general user has access privileges.All
SQL_DIV_TABLEAll1All1All
SQL_INDEX_COLINFAll1All1Table information about indexes for tables for which the general user has access privileges.All
SQL_TABLE_STATISTICSAllAllTable statistical information about tables for which the general user has access privileges.All
SQL_COLUMN_STATISTICSAllAllColumn statistical information about tables for which the general user has access privileges.All
SQL_INDEX_STATISTICSAllAllIndex statistical information about tables for which the general user has access privileges.All
SQL_VIEW_TABLE_USAGEAllAllTable information about view tables for which the general user has access privileges.All
SQL_VIEWSAllAllAll
SQL_DIV_INDEXAll1All1Table information about indexes for tables for which the general user has access privileges.All
SQL_DIV_COLUMNAll2All2Table information about tables for which the general user has access privileges.All
SQL_REFERENTIAL_CONSTRAINTSAllAllConstraint information about tables for which the general user has access privileges.All
SQL_ALIASESAllAllAllAll
SQL_ROUTINESAllAllAllAll
SQL_ROUTINE_RESOURCESAllAllAllAll
SQL_ROUTINE_PARAMSAllAllAllAll
SQL_DATATYPESAllAllAllAll
SQL_DATATYPE_DESCRIPTORSAllAllAllAll
SQL_TABLE_RESOURCESAllAllAllAll
SQL_PLUGINSAllAllAllAll
SQL_PLUGIN_ROUTINESAllAllAllAll
SQL_PLUGIN_ROUTINE_PARAMSAllAllAllAll
SQL_REGISTRYAllAllAllAll
SQL_INDEX_TYPESAllAllAllAll
SQL_INDEX_DATATYPEAllAllAllAll
SQL_INDEX_FUNCTIONAllAllAllAll
SQL_TYPE_RESOURCESAllAllAllAll
SQL_INDEX_RESOURCESAllAllAllAll
SQL_INDEX_TYPE_FUNCTIONAllAllAllAll
SQL_EXCEPTAll1All1Table information about indexes for tables for which the general user has access privileges.All
SQL_FOREIGN_SERVERSAllAllTable information about foreign servers that can be accessed.All
SQL_USER_MAPPINGSAllAllTable mapping information given to the general user.All
SQL_IOS_GENERATIONSAllAllAllAll
SQL_PARTKEYAllAllTable information about tables for which the general user has access privileges.All
SQL_PARTKEY_DIVISIONAllAllTable information about tables for which the general user has access privileges.All
SQL_TRIGGERSAllAllTable information about triggers defined by the general user.All
SQL_TRIGGER_COLUMNSAllAllAll
SQL_TRIGGER_DEF_SOURCEAllAllAll
SQL_TRIGGER_USAGEAllAllAll
SQL_AUDITSNoneAllNoneNone
SQL_KEYCOLUMN_USAGEAllAllTable information about tables for which the general user has access privileges.All
SQL_TABLE_CONSTRAINTSAllAllAll
SQL_CHECKSAllAllAll
SQL_CHECK_COLUMNSAllAllAll
SQL_DIV_TYPEAllAllAll
SQL_SYSPARAMSAllAllNoneNone

All: All columns can be referenced.

None: No columns can be referenced.

1 The base table of the data dictionary table cannot be referenced.

2 The base table of the data dictionary table can also be referenced.