In order to grant sysdba you must be in server manager and connected as
sysdba or internal.
Only someone with sysdba enabled can grant it.
Kenny Gump
OCP 7.3 DBA
suisum_at_ecn.ab.ca wrote in message <36a26b40.0_at_ecn.ab.ca>...
>I always got the following trhe following error:
>
>SQL> grant sysdba to scott;
>grant sysdba to scott
>*
>ERROR at line 1:
>ORA-01031: insufficient privileges
>
>I have set the REMOTE_LOGIN_PASSWORDFILE = exclusive. And I have built the
>password file by using orapwd80. How does Oracle know why I put the
>password file?
>
>I'm using Windows NT and Oracle 8.
>
>
>--
>Best regards,
Received on Mon Jan 18 1999 - 06:05:54 CST
