Re: Grant SYSDBA or SYSOPER privileges

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/ Received on Tue Jan 22 2002 - 16:01:11 CET