1.查看所有用户:
- k( V c- m% B# k select * from dba_users;
% X, M: X+ \6 }" {6 P7 y! }3 j, { select * from all_users;8 S$ ?) A3 R t9 _' ?9 a3 r/ L+ ^
select * from user_users;
6 p( l+ S5 m7 A8 Z ]; E: a 2.查磕暌姑户或脚色系统权限(直接赋值给用户或脚色的系统权限):
, w, x$ J, ~. c1 r select * from dba_sys_privs;
0 \( c5 Q) K- I2 L& f select * from user_sys_privs;5 j2 l; {: u. u# |; a1 [2 W
3.查看脚色(只能查看上岸用户拥有的脚色)所包含的权限
* Y& ?; V4 F4 F& ^1 l' r9 \; @/ o; T sql>select * from role_sys_privs;6 P$ t9 u, t9 Q( U5 y
4.查磕暌姑户对象权限:( {, }/ V! m3 w$ Y; Z( s. q
select * from dba_tab_privs;
( i4 ]8 v- Q4 @) |& r select * from all_tab_privs;8 c/ P) E2 W7 \; r; j8 s* z( S
select * from user_tab_privs;8 v$ S6 d* Q( ]5 a9 h# z
5.查看所有脚色:
+ W+ ^' k; [1 ?" k5 p" f! [ select * from dba_roles;
$ L% D4 c* s) G0 u, `/ ~& W 6.查磕暌姑户或脚色所拥有的脚色:
# d) O# J7 t3 l6 D* r select * from dba_role_privs;
. h) d: i4 E+ k5 T select * from user_role_privs;
8 J$ c2 f+ y. W/ R5 U) J 7.查看哪些用户有sysdba或sysoper系统权限(发芽时需要响应权限)3 c& V0 u5 l5 P0 b
select * from V$PWFILE_USERS |