如何查看Oracle的用戶權(quán)限？ORACL:有關(guān)用戶所擁有的對(duì)象信息，即用戶自己創(chuàng)建的對(duì)象信息ALL_*:有關(guān)用戶可以訪問的對(duì)象的信息，即用戶自己創(chuàng)建的對(duì)象的信息加上其他用戶創(chuàng)建的對(duì)象但該用戶有權(quán)訪問

如何查看Oracle的用戶權(quán)限？

ORACL:有關(guān)用戶所擁有的對(duì)象信息，即用戶自己創(chuàng)建的對(duì)象信息

ALL_*:有關(guān)用戶可以訪問的對(duì)象的信息，即用戶自己創(chuàng)建的對(duì)象的信息加上

其他用戶創(chuàng)建的對(duì)象但該用戶有權(quán)訪問的信息

DBA_*:有關(guān)整個(gè)數(shù)據(jù)庫(kù)中對(duì)象的信息

(這里的*可以為TABLES,INDEXES,OBJECTS,USERS等。)

1、查看所有用戶

select * from dba_user;

select * from all_users;

select * from user_users;

2、查看用戶系統(tǒng)權(quán)限

select * from dba_sys_privs;

select * from all_sys_privs;

select * from user_sys_privs;

3、查看用戶對(duì)象權(quán)限

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、查看當(dāng)前用戶的缺省表空間

select username,default_tablespace from user_users;

7、查看某個(gè)角色的具體權(quán)限

如grant connect,resource,create session,create view to TEST;

8、查看RESOURCE具有那些權(quán)限

用SELECT * FROM DBA_SYS_PRIVS WHERE GRANTEERESOURC

如何查看oracle每個(gè)連接占用的內(nèi)存大小？

Select Server, Osuser, Name, Value / 1024 / 1024 Mb, s.Sql_Id, Spid, s.*

From V$session s, V$sesstat St, V$statname Sn, V$process p

Where

And # #

AnI want to talk to pga memory and sort it by value Desc. Try this.