Oracle Security

Views Used for Security

Although the data dictionary views provide a wide range of information about the state of the database, the views shown in Table 4.1 are particularly important for providing security information. We’ve also listed the tables on which these views are built. We’ll examine each of the views listed in this table later in this chapter.

Table 4-1. Data Dictionary Views for Security

View Name	Type of Information Available	Tables on Which View Is Built
DBA_PROFILES[a]	Profiles and their associated resource and time limits	profile$, profname$, resouce_map, obj$
DBA_ROLES1	All roles that exist in the database	user$
DBA_ROLE_PRIVS1	Roles granted to users and other roles	user$, sysauth$, defrole$
DBA_SYS_PRIVS1	System privileges granted to users and roles	user$, sysauth$, system_privilege_map
DBA_TAB_PRIVS	Privileges like SELECT, INSERT, UPDATE, etc. that each user or role has per object	user$, objauth$, obj$, table_privilege_map
DBA_USERS	Who has an account for the database; also, which profile is assigned to the user	user$, ts$, profname$, profile$, user_astatus_map
ROLE_ROLE_PRIVS	Roles granted to roles	user$, sysauth$
ROLE_SYS_PRIVS	System privileges granted to roles	user$, system_privilege_map, sysauth$
ROLE_TAB_PRIVS	Table privileges granted to roles	user$, table_privilege_map, objauth$, obj$, col$
USER_ROLE_PRIVS	Roles granted to the current user	user$, sysauth$, defrole$, and x$kzdos
[a] These views do not have ...