Re: Grant SYSDBA or SYSOPER privileges

From: michael ngong <mngong_at_yahoo.com>
Date: 22 Jan 2002 12:43:23 -0800
Message-ID: <ecf365d5.0201221243.65321485_at_posting.google.com>


oraclems_at_hotmail.com (Murali) wrote in message news:<22e6597b.0201220701.7095054_at_posting.google.com>...
> farooq1974_at_hotmail.com (Qooraf) wrote in message news:<33f31376.0201212143.69272d18_at_posting.google.com>...
> > postbus_at_sybrandb.demon.nl (Sybrand Bakker) wrote in message news:<a20d28ee.0201210102.1429ff20_at_posting.google.com>...
> > > farooq1974_at_hotmail.com (Qooraf) wrote in message news:<33f31376.0201181547.c368d93_at_posting.google.com>...
> > > > Can somebody tell me how to grant SYSDBA or SYSOPER privileges to a user.
> > > > Thanks.
> > > > ~Farooq
> > >
> > > make sure init.ora parameter remote_login_password_file is set to exclusive
> > > grant sysdba|sysoper to user
> > >
> > > The other answer is incorrect.
> > >
> > > Hth
> > >
> > > Sybrand Bakker
> > > Senior Oracle DBA
> >
> >
> > Thanks Sybrand, I have checked, init.ora parameter
> > remote_login_password_file is set to exclusive but this statement
> > "grant sysdba to user" or "grant sysoper to user" is not working.
> > Anyway Thanks, any other suggestion.
> > ~Farooq
>
>
> Who are you logged in as ? Connect as sysdba and try.
>
> $ sqlplus "sys/change_on_install as sysdba"
> SQL> grant sysdba to scott;
>
> Murali
> http://www.dbaquest.com/

shutdown your DB
set remote login password file =exclusive in init<SID>.ora file go to $ORACLE_HOME/dbs
run command below all on the same line

orapwd file=orapw<your sid here>
password=<put an appropriate password here> entries=<put the number of people and about 3 more you want to give sysdba privs to>

after this you will find a file called orapw< your sid> You are all set
start up your database
grant sysdba to anyuser and your database would have learnt to obey you Thanks
Michael Tubuo Ngong Received on Tue Jan 22 2002 - 21:43:23 CET

Original text of this message