Micro Focus Enterprise Developer 3.0 for Eclipse > Programming > Mainframe Programming > SQL Option for DB2 > SQL Option Server Administration Guide > Security and Authority > Granted Authorities and Privileges > The DSNDB06 Database

The DSNDB06 Database

Restriction: This topic applies to Windows environments only.

The DSNDB06 database, which is a system catalog database provided in each location, contains the specific authorities and privileges that you define for each AuthID, SecondaryID or GroupID with the SQL GRANT and REVOKE commands. This information is stored in the following security-related tables:

SYSIBM.SYSDBAUTH (Database Authorization)
SYSIBM.SYSUSERAUTH (User Authorization)
SYSIBM.SYSTABAUTH (Table Authorization)
SYSIBM.SYSCOLAUTH (Column Authorization)

See the SQL Reference for a complete definition of each of these tables.