System tables containing information about user IDs, roles, and privileges.
All tables and views are owned by the SYS role, and their qualified names are SYS.ISYSUSERPERM, SYS.ISYSTABLEPERM, and so on. Execute the appropriate SELECT queries on these tables generate all the user ID and privilege information stored in the database.
Table |
Default |
Contents |
|---|---|---|
ISYSUSERPERM |
SELECT ANY TABLE system privilege |
Database-level privileges and password for each user ID |
ISYSTABLEPERM |
PUBLIC |
All privileges on table given by the GRANT commands |
ISYSCOLPERM |
PUBLIC |
All columns with UPDATE privilege given by the GRANT command |
ISYSPROCPERM |
PUBLIC |
Each row holds one user granted privilege to use one procedure |