Security - Oracle SQL Jumpstart with Examples - page 530

23.4 Metadata Views

This section simply describes metadata views applicable to users, privileges,
and roles. Chapter 19 describes the basis and detail of Oracle Database
metadata views.

USER_USERS . Information on the logged-in user. ALL_USERS
and DBA_USERS detail information for all users currently existing
in the database.
USER_SYS_PRIVS . Granted system privileges.
USER_TAB_PRIVS[_MADE|RECD] . All object privileges (granted
to and from plus owned). MADE and RECD implies granted object
privileges and grantee object privileges, respectively.

Note: The term grantee implies that a user has been granted a privilege by
another user.

USER_COL_PRIVS[_MADE|RECD] . As for USER_TAB_PRIVS
but as applied to specific columns only, not entire tables.
ROLE_PRIVS . Roles granted to a user, both enabled and disabled.
USER_ROLE_PRIVS . Roles granted to the connected user, both
enabled and disabled.
SESSION_ROLES . A connected session's enabled roles.
ROLE_ROLE_PRIVS . Roles granted to other roles.
ROLE_TAB_PRIVS . Object privileges granted to roles.
ROLE_SYS_PRIVS . System privileges granted to roles.
DBA_ROLE_PRIVS . Roles granted to users and other roles, who or
which role granted it to the user or role, respectively, and whether the
user has WITH ADMIN OPTION for the role.

This chapter has described security and controlling database access using
users, both system and object privileges, and finally privilege groupings
using roles. The next chapter, the final chapter in this topic, digresses from
Oracle SQL more so than this chapter, examining the very basics of Pro-
gramming Language/SQL (PL/SQL).