oracle用户privilege和role查询
版权说明：一下来自oracle官方文档。
1.查询当前用户被授予的role
USER_ROLE_PRIVS 相关动态性能视图 DBA_ROLE_PRIVS
USER_ROLE_PRIVS describes the roles granted to the current user.
| Column | Datatype | NULL | Description |
|---|---|---|---|
| USERNAME | VARCHAR2(30) | Name of the user, or PUBLIC | |
| GRANTED_ROLE | VARCHAR2(30) | Name of the role granted to the user | |
| ADMIN_OPTION | VARCHAR2(3) | Indicates whether the grant was with the ADMIN OPTION (YES) or not (NO) | |
| DEFAULT_ROLE | VARCHAR2(3) | Indicates whether the role is designated as a DEFAULT ROLE for the user (YES) or not (NO) | |
| OS_GRANTED | VARCHAR2(3) |
Granted by the operating system (YES) or not (NO); occurs if configuration parameter OS_ROLES = true. |
2.当前用户被授予了那些system权限
USER_SYS_PRIVS 相关动态性能视图有 DBA_SYS_PRIVS
DBA_SYS_PRIVS describes system privileges granted to users and roles. This view does not display the USERNAME column.
USER_SYS_PRIVS describes system privileges granted to the current user. This view does not display the GRANTEE column, but instead displays the USERNAMEcolumn.
| Column | Datatype | NULL | Description |
|---|---|---|---|
| GRANTEE | VARCHAR2(30) | NOT NULL | Grantee name, user, or role receiving the grant |
| USERNAME | VARCHAR2(30) | Name of the current user | |
| PRIVILEGE | VARCHAR2(40) | NOT NULL | System privilege |
| ADMIN_OPTION | VARCHAR2(3) |
Grant was with the ADMIN option |
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29249734/viewspace-1843508/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
ORACLE 绑定变量用法总结
下一篇：
没有了~
请登录后发表评论
登录
全部评论
最新文章
- ORACLE 绑定变量用法总结
- Redo Transport Services之What to Do If Errors Occur
- oracle11g RAC之 profile.xml配置文件
- Redo Transport Services之When and How to send redo data
- Oracle10.2.0.1 DataGuard部署
- oracle11g各版本下载地址
- oracle10.2.0.1升级到10.2.0.4
- oracle listener.ora和tnsnames.ora
- linux 5.5 x86_x64下安装oracle 10.2.0.1
- history_xcy君rm -rf恢复后记--ext3grep安装说明
