Filter
Top Products
CHAPTER 10 Managing User IDs and Permissions
375
The following table summarizes the system views containing information
about user IDs, groups, and permissions.
In addition to these, there are tables and views containing information about
each object in the database.
Table Default Contents
SYSUSERPERM DBA only Database-level permissions and
password for each user ID
SYSGROUP PUBLIC One row for each member of each
group
SYSTABLEPERM PUBLIC All permissions on table given by
the GRANT commands
SYSCOLPERM PUBLIC All columns with UPDATE
permission given by the GRANT
command
SYSDUMMY PUBLIC Dummy table, can be used to find
the current user ID
SYSPROCPERM PUBLIC Each row holds one user granted
permission to use one procedure
Views Default Contents
SYSUSERAUTH DBA only All information in
SYSUSERPERM except for user
numbers
SYSUSERPERMS PUBLIC All information in
SYSUSERPERM except for
passwords
SYSUSERLIST PUBLIC All information in
SYSUSERAUTH except for
passwords
SYSGROUPS PUBLIC Information from SYSGROUP in a
more readable format
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