Home » RDBMS Server » Server Administration » DBA password
DBA password [message #50223] Wed, 06 March 2002 10:29 Go to next message
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.
Re: DBA password [message #50224 is a reply to message #50223] Wed, 06 March 2002 10:35 Go to previous messageGo to next message
saleem
Messages: 65
Registered: January 2002
Member
granting dba should give you all you need.
Re: DBA password [message #50227 is a reply to message #50223] Wed, 06 March 2002 10:46 Go to previous messageGo to next message
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....
Re: DBA password [message #50230 is a reply to message #50227] Wed, 06 March 2002 10:58 Go to previous message
shafik
Messages: 13
Registered: March 2002
Junior Member
And what about SYSTEM ? Whats the diff between sys and system ?
Previous Topic: Export/Import
Next Topic: Dropping column in 7.3.4
Goto Forum:
  


Current Time: Tue Dec 24 20:35:02 CST 2024