Access Privileges on Tables

The discretionary access privileges on a table describe both who can access the information in the table and who can create new tables.

For more information about discretionary access privileges, see the description of the GRANT statement statement.

In an ANSI-compliant database, no default table-level privileges exist. You must grant these privileges explicitly.

Setting the environment variable NODEFDAC to yes prevents default privileges from being granted to PUBLIC on new tables in a database that is not ANSI compliant, as described in the HCL OneDB™ Guide to SQL: Reference.

Important: Enabling NODEFDAC withholds default table access or routine access privileges from PUBLIC when the object is registered in the system catalog, but the NODEFDAC setting cannot prevent the PUBLIC group from being granted the same privileges by a user who holds the necessary access privileges on the new table or on the new UDR.

For more information about discretionary access privileges, see the HCL OneDB Guide to SQL: Tutorial.