OraFAQ Forum: Performance Tuning » can we grant SYSDBA privilege to SYSTEM user ?

Home » RDBMS Server » Performance Tuning » can we grant SYSDBA privilege to SYSTEM user ?

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

can we grant SYSDBA privilege to SYSTEM user ? [message #233907]

Sat, 28 April 2007 01:51

kesevan
Messages: 17
Registered: April 2007
Location: MUMABI

Junior Member

Dear all,

I can connect as SYSTEM...but i don't have SYSDBA privilege.... but i need this privilege to generate statspack report and to check v$sysstat settings....

can we grant this SYSDBA privilege to SYSTEM...?

or is there any other alternate to check v$sysstat values and to generate the statspack at database level ?

pls clarify me...

thank you all.
kesavan.

Report message to a moderator

Re: can we grant SYSDBA privilege to SYSTEM user ? [message #233914 is a reply to message #233907]

Sat, 28 April 2007 02:30

Michel Cadot
Messages: 68704
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

1/ You don't need sysdba to generate a statspack report. SYSDBA is only for database maintenance purpose (startup, shutdown...)
2/ Yes you can give sysdba to system but you should not use system (create your own dba account) and you should not give sysdba to system
3/ you can directly query on v$sysstat, you don't need to use statspack but statspack is really useful and ready.

Regards
Michel

Report message to a moderator

Previous Topic:	PARALLEL - Hint not working!!!
Next Topic:	JUNIOR DBA

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 04 19:06:58 CST 2024