达梦数据库中权限相关的视图介绍
登录用户被授予的对象权限
select * from USER_TAB_PRIVS;
登录用户被授予的对象权限
select * from USER_TAB_PRIVS;
登录用户被授予的系统权限
select * from USER_SYS_PRIVS;
登录用户被授予的角色
select * from USER_ROLE_PRIVS;
登录用户被授予的列对象权限
select * from USER_COL_PRIVS;
登录用户被授予的会话权限
select * from SESSION_PRIVS;
所有用户被授予的对象权限
select * from DBA_TAB_PRIVS;
所有用户被授予的系统权限
select * from DBA_SYS_PRIVS;
所有用户被授予的角色
select * from DBA_ROLE_PRIVS;
所有用户被授予的列对象权限
select * from DBA_COL_PRIVS;
所有表权限
select * from ALL_TAB_PRIVS;
所有列权限
select * from ALL_COL_PRIVS;
整理到一起的语句,方便大家保存记录
select * from USER_TAB_PRIVS;
select * from USER_SYS_PRIVS;
select * from USER_ROLE_PRIVS;
select * from USER_COL_PRIVS;
select * from SESSION_PRIVS;
select * from DBA_TAB_PRIVS;
select * from DBA_SYS_PRIVS;
select * from DBA_ROLE_PRIVS;
select * from DBA_COL_PRIVS;
select * from ALL_TAB_PRIVS;
select * from ALL_COL_PRIVS;