oracle数据库的表权限,oracle表中的权限表

SQL> select * from dictionary where table_name like '%PRIVS%';

TABLE_NAME           COMMENTS

-------------------- ----------------------------------------

ALL_COL_PRIVS        Grants on columns for which the user is

the grantor, grantee, owner,

or an enabled role or PUBLIC is the gra

ntee

ALL_COL_PRIVS_MADE   Grants on columns for which the user is

owner or grantor

ALL_COL_PRIVS_RECD   Grants on columns for which the user, PU

BLIC or enabled role is the grantee

TABLE_NAME           COMMENTS

-------------------- ----------------------------------------

ALL_TAB_PRIVS        Grants on objects for which the user is

the grantor, grantee, owner,

or an enabled role or PUBLIC is the gra

ntee

ALL_TAB_PRIVS_MADE   User's grants and grants on user's objec

ts

ALL_TAB_PRIVS_RECD   Grants on objects for which the user, PU

BLIC or enabled role is the grantee

TABLE_NAME           COMMENTS

-------------------- ----------------------------------------

DBA_AQ_AGENT_PRIVS

DBA_COL_PRIVS        All grants on columns in the database

DBA_ROLE_PRIVS       Roles granted to users and roles

DBA_RSRC_CONSUMER_GR Switch privileges for consumer groups

OUP_PRIVS

DBA_RSRC_MANAGER_SYS system privileges for the resource manag

TEM_PRIVS            er

DBA_SYS_PRIVS        System privileges granted to users and r

oles

TABLE_NAME           COMMENTS

-------------------- ----------------------------------------

DBA_TAB_PRIVS        All grants on objects in the database

USER_AQ_AGENT_PRIVS

USER_COL_PRIVS       Grants on columns for which the user is

the owner, grantor or grantee

USER_COL_PRIVS_MADE  All grants on columns of objects owned b

y the user

USER_COL_PRIVS_RECD  Grants on columns for which the user is

the grantee

TABLE_NAME           COMMENTS

-------------------- ----------------------------------------

USER_ROLE_PRIVS      Roles granted to current user

USER_RSRC_CONSUMER_G Switch privileges for consumer groups fo

ROUP_PRIVS           r the user

USER_RSRC_MANAGER_SY system privileges for the resource manag

STEM_PRIVS           er for the user

USER_SYS_PRIVS       System privileges granted to current use

r

TABLE_NAME           COMMENTS

-------------------- ----------------------------------------

USER_TAB_PRIVS       Grants on objects for which the user is

the owner, grantor or grantee

USER_TAB_PRIVS_MADE  All grants on objects owned by the user

USER_TAB_PRIVS_RECD  Grants on objects for which the user is

the grantee

ROLE_ROLE_PRIVS      Roles which are granted to roles

ROLE_SYS_PRIVS       System privileges granted to roles

ROLE_TAB_PRIVS       Table privileges granted to roles

SESSION_PRIVS        Privileges which the user currently has

TABLE_NAME           COMMENTS

-------------------- ----------------------------------------

set

GV$ENABLEDPRIVS      Synonym for GV_$ENABLEDPRIVS

V$ENABLEDPRIVS       Synonym for V_$ENABLEDPRIVS

已选择30行。

SQL>