User ID, Role, and Privilege Information in System Views

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