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 (deprecated) | SELECT ANY TABLE system privilege | All information in SYSUSERPERM (deprecated) except user numbers |
SYSUSERPERMS (deprecated) | PUBLIC | All information in SYSUSERPERM (deprecated) except passwords |
SYSUSERLIST (deprecated) | PUBLIC | All information in SYSUSERAUTH (deprecated) 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 |