Catalog tables with privilege records
An authorization ID can hold different privileges. Db2 records information about the privileges of an ID in catalog tables.
The following catalog tables contain information about the
privileges that IDs can hold:
| Table name | Records privileges held for or authorization related to |
|---|---|
| SYSIBM.SYSCOLAUTH | Updating columns |
| SYSIBM.SYSDBAUTH | Databases |
| SYSIBM.SYSPLANAUTH | Plans |
| SYSIBM.SYSPACKAUTH | Packages |
| SYSIBM.SYSRESAUTH | Buffer pools, storage groups, collections, table spaces, JARs, and distinct types |
| SYSIBM.SYSROUTINEAUTH | User-defined functions and stored procedures |
| SYSIBM.SYSSCHEMAAUTH | Schemas |
| SYSIBM.SYSTABAUTH | Tables and views |
| SYSIBM.SYSUSERAUTH | System authorities |
| SYSIBM.SYSSEQUENCEAUTH | Sequences |
| SYSIBM.SYSCONTEXT | Associating a role with a trusted context |
| SYSIBM.SYSCTXTTRUSTATTRS | Associating trust attributes with a trusted context |
| SYSIBM.SYSCONTEXTAUTHIDS | Associating users with a trusted context |
