OraFAQ Forum: Security » system privilege / Role

Home » RDBMS Server » Security » system privilege / Role

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

system privilege / Role [message #128305]

Sun, 17 July 2005 12:48

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

Report message to a moderator

Re: system privilege / Role [message #128435 is a reply to message #128305]

Mon, 18 July 2005 09:07

Frank Naude
Messages: 4596
Registered: April 1998

Senior Member

It depends on what access the tool requires. My first guess would be SELECT ANY DICTIONARY:

Code: [Select all] [Show/ hide]

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 05 01:09:30 CDT 2025