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 to 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 who is granted the privilege to use one procedure |