System views containing information about user IDs, roles, and privileges.
In addition to this list, there are tables and views containing information about each object in the database.
View |
Default |
Contents |
---|---|---|
SYSUSERAUTH |
SELECT ANY TABLE system privilege |
All information in SYSUSERPERM except user numbers |
SYSUSERPERMS |
PUBLIC |
All information in SYSUSERPERM except passwords |
SYSUSERLIST |
PUBLIC |
All information in SYSUSERAUTH except passwords |
SYSTABAUTH |
PUBLIC |
Information from SYSTABLEPERM in a more readable format |
SYSCOLAUTH |
PUBLIC |
Information from SYSCOLPERM in a more readable format |
SYSPROCAUTH |
PUBLIC |
Information from SYSPROCPERM in a more readable format |