Home » RDBMS Server » Security » system privilege / Role
system privilege / Role [message #128305] Sun, 17 July 2005 12:48 Go to next message
Hina
Messages: 51
Registered: April 2004
Member
What SYSTEM PRIVILEGE / ROLE require for a normal user to monitor database performance / statistics using tool ?

e.g. cpu usage, sga allocation, query taking enough resources etc.

Regards

Re: system privilege / Role [message #128435 is a reply to message #128305] Mon, 18 July 2005 09:07 Go to previous message
Frank Naude
Messages: 4569
Registered: April 1998
Senior Member
It depends on what access the tool requires. My first guess would be SELECT ANY DICTIONARY:

SQL> create user tool identified by tool;

User created.

SQL> grant SELECT ANY DICTIONARY  to tool;

Grant succeeded.

SQL> grant CONNECT to tool;

Grant succeeded.

SQL> conn tool/tool
Connected.
SQL> select * from sys.v_$sga;

NAME                      VALUE
-------------------- ----------
Fixed Size              1301536
Variable Size         262677472
Database Buffers       25165824
Redo Buffers             262144


Best regards.

Frank
Previous Topic: i want to get a previllege
Next Topic: SYSDBA Auditing
Goto Forum:
  


Current Time: Fri Sep 24 05:20:10 CDT 2021