The earlier discussions on the data dictionary views focused on the privileges that relate to specific database objects. You may also want to know what privileges have been granted to a particular user.
There are two ways to get this information. You can log on as the user in question and query their
You can also query the equivalent
tables with selection criteria that would limit the results to a particular user, as in:
SELECT * FROM ALL_TAB_PRIVS
WHERE GRANTEE = 'SCOTT';
This would give you a listing of all the privileges granted for all tables to the user named
The next lesson shows how to give a user the ability to grant privileges.