User Privilege Views

You can view the privileges granted to each user through certain views.

Table 2-3 System Views for User Privileges

View Name	Description
SYS.USER_SYS_PRIVS	Returns all of the system privileges granted to the current user.
SYS.DBA_SYS_PRIVS	Returns the list of system privileges granted to all users and inherited from the PUBLIC role. ADMIN privilege is required to select from this view.
SYS.USER_TAB_PRIVS	Returns all of the object privileges granted to the current user.
SYS.ALL_TAB_PRIVS	Returns the results of both USER_TAB_PRIVS and the object privileges inherited from the PUBLIC role for a user. This shows all object privileges granted to a user.
SYS.DBA_TAB_PRIVS	Returns the object privileges granted to all users and inherited from the PUBLIC role. ADMIN privilege is required to select from this view.

This example displays the system privileges granted to all users:

Command> SELECT * FROM SYS.DBA_SYS_PRIVS;
< SYS, ADMIN, YES >
< SYSTEM, ADMIN, YES >
< TERRY, ADMIN, YES >
< TERRY, CREATE ANY TABLE, NO >
< PAT, CACHE_MANAGER, NO >
5 rows found.

Note:

See System Tables and Views in Oracle TimesTen In-Memory Database System Tables and Views Reference.