一、查看当前用户信息:
1、查看当前用户拥有的角色权限信息:select * from role_sys_privs;
2、查看当前用户的详细信息:select * from user_users;
3、查看当前用户的角色信息:select * from user_role_privs;
二、常用查询
1.查看所有用户:
select * from dba_user;
select * from all_users;
select * from user_users;
2.查看用户系统权限:
select * from dba_sys_privs;
select * from all_sys_privs;
select * from user_sys_privs;
3.查看用户对象权限:
select * from dba_tab_privs;
select * from all_tab_privs;
select * from user_tab_privs;
4.查看所有角色:
select * from dba_roles;
5.查看用户所拥有的角色:
select * from dba_role_privs;
select * from user_role_privs;
6.查看角色所拥有的权限:
select * from role_sys_privs;
select * from role_tab_privs;
7.查看所有系统权限
select * from system_privilege_map;
8.查看所有对象权限
select * from table_privilege_map;
9.Oracle查询所有函数和储存过程:select * from user_source
10.Oracle查询所有用户:select * from all_users.select * from dba_users
11.Oracle查看当前用户连接:select * from v$Session
12.Oracle查看当前用户权限:select * from session_privs
其他
1.查看表结构:desc表名
2.查看当前用户的表:
select table_name from user_tables;
3.查看所有用户的表名:
select table_name from all_tables;
4.查看数据库名:
select name from v$database; /**/
5.查看sid:
select instance_name from v$instance;