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

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

阅读量：4566 次

发布时间：2019-06-08

本文共 1009 字，大约阅读时间需要 3 分钟。

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

于是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`)