Regarding sysdba

[hopexxx]

Hi ,
I have installed Personal Oracle 9i on WinXP. I am able to login by using default user roles as scott, system . I want to login as sysdba . I created a user sysdba but am unable to grant any priviledges to that role. I am trying to grant priviledges by connecting as system. I created sysdba by using the below command
create role sysdba identified by sysdba
please tell me how to proceed further.
Thanks in advance

 

[Turkbear]

Hi, unless Personal is very different from Enterprise
( and it may well be) the SYSDBA is not 'really' a role that needs to be created..

Grant sysdba to scott for instance and you then log in like:
connect scott/tiger as sysdba

 

[cliousa]

The SYSDBA role is already there. Simple grant it to the user:

$ sqlplus /nolog

SQL*Plus: Release 9.0.1.3.0 - Production on Thu May 8 15:50:11 2003

(c) Copyright 2001 Oracle Corporation. All rights reserved.

SQL> connect / as sysdba
Connected.

SQL> grant sysdba to scott;

Grant succeeded.


Hope that helps,

clio_usa - OCP DBA
------------------

http://www.dbaclick.com