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

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