tab 被字面的意思迷惑了,DBA_TAB_PRIVS

今天创建一个过程报编译错误

 

于是show error 找到了 错误的地方

 

是对一个包没有执行权限

 

于是想多个数据库对比下用户权限

 

结果看到DBA_TAB_PRIVS以为是表的权限，直接忽略了

 

悲催啊，

 

DBA_TAB_PRIVS

DBA_TAB_PRIVS describes all object grants in the database.

Related View

USER_TAB_PRIVS describes the object grants for which the current user is the object owner, grantor, or grantee.

Column	Datatype	NULL	Description
GRANTEE	VARCHAR2(30)	NOT NULL	Name of the user to whom access was granted
OWNER	VARCHAR2(30)	NOT NULL	Owner of the object
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the object. The object can be any object, including tables, packages, indexes, sequences, and so on.
GRANTOR	VARCHAR2(30)	NOT NULL	Name of the user who performed the grant
PRIVILEGE	VARCHAR2(40)	NOT NULL	Privilege on the object
GRANTABLE	VARCHAR2(3)		Indicates whether the privilege was granted with the GRANT OPTION(YES) or not (NO)
HIERARCHY	VARCHAR2(3)		Indicates whether the privilege was granted with the HIERARCHY OPTION (YES) or not (NO)

转载于:https://www.cnblogs.com/4admin2root/archive/2012/08/11/2633355.html