Re: Grant SYSDBA or SYSOPER privileges
Date: 21 Jan 2002 21:43:09 -0800
Message-ID: <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
Received on Tue Jan 22 2002 - 06:43:09 CET