介绍
DBA_TAB_PRIVS视图提供了查询所有对象的授权信息，我们可以查看该视图来获取到对象的拥有者是谁、对象授权给了谁，以及授的什么权限等。
视图详情
| 字段名 | 字段类型 | 描述 | 译 | 备注 |
| GRANTEE | VARCHAR2(30) | Name of the user or role to whom access was granted | 授予访问权限的用户或角色的名称 | |
| OWNER | VARCHAR2(64) | Owner of the object | 对象的拥有者，或者叫创建者 | |
| TABLE_NAME | VARCHAR2(30) | Name of the object. The object can be any object, including tables, packages, indexes, sequences, and so on. | 对象名，该对象可以是任何对象，例如：表、包、索引、序列等 | |
| GRANTOR | VARCHAR2(30) | Name of the user who performed the grant | 执行授权的用户名称 | |
| PRIVILEGE | VARCHAR2(40) | Privilege on the object | 授权的权限名称 | |
| GRANTABLE | VARCHAR2(3) | Indicates whether the privilege was granted with the GRANT OPTION (YES) or not (NO) | 被授权的用户是否能将授权的对象再授权给其他用户，YES-可以，NO-不可以 | |
| HIERARCHY | VARCHAR2(3) | Indicates whether the privilege was granted with the HIERARCHY OPTION (YES) or not (NO) | 授权的对象是否包括子对象一起，YES-包括，NO-不包括 | 仅用于查询(select)权限 |
评论区