You can obtain information about security privileges from the data dictionary views. You can also get information about privileges granted at the column level and query the data dictionary for information about privileges for each user.
You can grant object privileges for individual columns as well as tables. Just as there are three views that contain information about the privileges on tables, there are three corresponding data dictionary views for column privileges:
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.