The following table summarizes the system tables containing information about user IDs, groups, and permissions.
All tables and views are owned by user ID SYS, and so their qualified names are SYS.SYSUSERPERM and so on.
Appropriate SELECT queries on these tables generate all the user ID and permission information stored 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 |
SYSPROCPERM |
PUBLIC |
Each row holds one user granted permission to use one procedure |