First page Back Continue Last page Graphics

DBA_TAB_PRIVS


Notes:

There are several data dictionary views that reveal what object-level privileges have been granted directly to a user, by a user, or even simply involve one of the user’s objects. These are:
DBA_TAB_PRIVS – contains a row for every grant issued on every table in the database.
USER_TAB_PRIVS records the object-level privileges that have been either granted or received by the user, or involve the user’s object.
USER_COL_PRIVS shows the column object-level privileges that have been granted or received by the user, or involve the user’s object. (INSERT, UPDATE and REFERENCES can be specified at the column level).
Refer to the Oracle9i Database Reference for complete descriptions of these and all data dictionary views.