January 2005
Beginner to intermediate
928 pages
22h 14m
English
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 ... |
Read now
Unlock full access