3.关于查询数据库用户,权限的相关语句:
Sql代码
1. 1.查看所有用户:
2.select * from dba_user;
3.select * from all_users;
4.select * from user_users;
5.
6.
7. 2.查看用户系统权限:
8.select * from dba_sys_privs;
9.select * from all_sys_privs;
10.select * from user_sys_privs;
11.
12.
13.3.查看用户对象权限:
14.select * from dba_tab_privs;
15.select * from all_tab_privs;
16.select * from user_tab_privs;
17.
18.
19.4.查看所有角色:
20.select * from dba_roles;
21.
22.
23.5.查看用户所拥有的角色:
24.select * from dba_role_privs;
25.select * from user_role_privs;
4.几个经常用到的oracle视图:注意表名使用大写.................... Sql代码
1. 1. 查询oracle中所有用户信息
2. select * from dba_user;
3. 2. 只查询用户和密码
4. select username,password from dba_users;
5. 3. 查询当前用户信息
6. select * from dba_ustats;
7. 4. 查询用户可以访问的视图文本
8. select * from dba_varrays;
9. 5. 查询数据库中所有视图的文本