10.6. Authority and Privilege Metadata
Up to this point we have introduced different authorities and privileges. Now we will show you where all these security information is stored and how to easily retrieve it.
Just like most of the information about a database, authorities and privileges metadata is stored in the catalog tables and views listed in Table 10.10. For a complete list of all DB2 catalog tables and descriptions, refer to Appendix D, Using the DB2 System Catalog Tables, or the DB2 UDB SQL Reference manual.
Catalog View | Description |
---|---|
SYSCAT.COLAUTH | Stores column privileges for each grantee. Column privileges are granted through table and view privileges. The two ... |
Get Understanding DB2®: Learning Visually with Examples now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.