一:用户查看
A : select * from dba_users
B: select * from all_users
C: select * from user_users
二:权限查看
A:select * from user_sys_privs
B:select * from user_tab_privs
C:select * from user_col_privs
D:select * from dba_sys_privs
E:select * from dba_tab_privs
F:select * from dba_col_privs
G:select * from session_pivs
三:角色查看
A:select * from dba_roles
B:select * from user_roles_privs
C:select * from dba_roles_privs
Oracle数据库用户查看操作
于 2016-08-02 09:50:32 首次发布