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:

• Database initialization utility: dicinf operand of define system statement
• Database structure modification utility: dicinf operand of alter system statement

The following table 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 table	dicinf operand value
	limited			unlimited
	DBA privilege holders	Auditor	General users
SQL_PHYSICAL_FILES	All	All	Table information about HiRDB files that comprise RDAREAs for which the general user has usage privileges.	All
SQL_RDAREAS	All	All	Table information about RDAREAs for which the general user has usage privileges.	All
SQL_TABLES	All#1	All#1	Table information about tables for which the general user has access privileges.	All
SQL_COLUMNS	All#1	All#1	Table information about columns in tables for which the general user has access privileges.	All
SQL_INDEXES	All#1	All#1	Table information about indexes for tables for which the general user has access privileges.	All
SQL_USERS	All	All	None	None
SQL_RDAREA_PRIVILEGES	All	All	Table information about RDAREAs for which the general user has access privileges.	All
SQL_TABLE_PRIVILEGES	All#1	All#1	Table information about tables for which the general user has access privileges.	All
SQL_DIV_TABLE	All#1	All#1		All
SQL_INDEX_COLINF	All#1	All#1	Table information about indexes for tables for which the general user has access privileges.	All
SQL_TABLE_STATISTICS	All	All	Table statistical information about tables for which the general user has access privileges.	All
SQL_COLUMN_STATISTICS	All	All	Column statistical information about tables for which the general user has access privileges.	All
SQL_INDEX_STATISTICS	All	All	Index statistical information about tables for which the general user has access privileges.	All
SQL_VIEW_TABLE_USAGE	All	All	Table information about view tables for which the general user has access privileges.	All
SQL_VIEWS	All	All		All
SQL_DIV_INDEX	All#1	All#1	Table information about indexes for tables for which the general user has access privileges.	All
SQL_DIV_COLUMN	All#2	All#2	Table information about tables for which the general user has access privileges.	All
SQL_REFERENTIAL_CONSTRAINTS	All	All	Constraint information about tables for which the general user has access privileges.	All
SQL_ALIASES	All	All	All	All
SQL_ROUTINES	All	All	All	All
SQL_ROUTINE_RESOURCES	All	All	All	All
SQL_ROUTINE_PARAMS	All	All	All	All
SQL_DATATYPES	All	All	All	All
SQL_DATATYPE_DESCRIPTORS	All	All	All	All
SQL_TABLE_RESOURCES	All	All	All	All
SQL_PLUGINS	All	All	All	All
SQL_PLUGIN_ROUTINES	All	All	All	All
SQL_PLUGIN_ROUTINE_PARAMS	All	All	All	All
SQL_REGISTRY	All	All	All	All
SQL_INDEX_TYPES	All	All	All	All
SQL_INDEX_DATATYPE	All	All	All	All
SQL_INDEX_FUNCTION	All	All	All	All
SQL_TYPE_RESOURCES	All	All	All	All
SQL_INDEX_RESOURCES	All	All	All	All
SQL_INDEX_TYPE_FUNCTION	All	All	All	All
SQL_EXCEPT	All#1	All#1	Table information about indexes for tables for which the general user has access privileges.	All
SQL_IOS_GENERATIONS	All	All	All	All
SQL_PARTKEY	All	All	Table information about tables for which the general user has access privileges.	All
SQL_PARTKEY_DIVISION	All	All	Table information about tables for which the general user has access privileges.	All
SQL_TRIGGERS	All	All	Table information about triggers defined by the general user.	All
SQL_TRIGGER_COLUMNS	All	All		All
SQL_TRIGGER_DEF_SOURCE	All	All		All
SQL_TRIGGER_USAGE	All	All		All
SQL_AUDITS	None	All	None	None
SQL_KEYCOLUMN_USAGE	All	All	Table information about tables for which the general user has access privileges.	All
SQL_TABLE_CONSTRAINTS	All	All		All
SQL_CHECKS	All	All		All
SQL_CHECK_COLUMNS	All	All		All
SQL_DIV_TYPE	All	All		All
SQL_SYSPARAMS	All	All	None	None
SQL_INDEX_XMLINF	All	All	Table information about tables for which the general user has access privileges.	All
SQL_SEQUENCES	All	All	Table information about sequence generator identifiers defined by the general user.	All

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.