OraFAQ Forum: Server Administration » DBA password

Home » RDBMS Server » Server Administration » DBA password

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

DBA password [message #50223]

Wed, 06 March 2002 10:29

srs
Messages: 5
Registered: March 2002

Junior Member

I've been given passwords for SYS and SYSTEM for my PROD/DEV/TEST databases. How do I grant full DBA privileges to myself. I gave 'grant dba to sshamji' from SYS. Is that right ? I want to know the
command to give all privileges to myself you know what i mean. Replys appreciated.

Report message to a moderator

Re: DBA password [message #50224 is a reply to message #50223]

Wed, 06 March 2002 10:35

saleem
Messages: 65
Registered: January 2002

Member

granting dba should give you all you need.

Report message to a moderator

Re: DBA password [message #50227 is a reply to message #50223]

Wed, 06 March 2002 10:46

Helena
Messages: 42
Registered: February 2002

Member

You also can do the following
grant sys dba to "whatever" this way you have full priviliges as sys....

Report message to a moderator

Re: DBA password [message #50230 is a reply to message #50227]

Wed, 06 March 2002 10:58

shafik
Messages: 13
Registered: March 2002

Junior Member

And what about SYSTEM ? Whats the diff between sys and system ?

Report message to a moderator

Previous Topic:	Export/Import
Next Topic:	Dropping column in 7.3.4

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 08 11:14:03 CDT 2024