Re: problem with grant sysdba to user

"Ed Stevens" <Ed_Stevens_at_nospam.noway.nohow> wrote in message news:3b7aac93.192053418_at_ausnews.austin.ibm.com...
> Ok, time for some long overdue education. We're starting to move from
> 8.0.5 to 8.1.7, and looking at OS authentication for the first time.
>
> On the server, Oracle created the group ORACLE_DBA, and placed my
> domain userid in it when I installed 8.17 (no previous versions of Ora
> on this machine.) Domain is "xyz" and my userid is PUR003.
>
> Connected as SYSTEM and created user PUR003 IDENTIFIED EXTERNAL. Then
> did the following:
>
> SQL*Plus: Release 8.1.7.0.0 - Production on Wed Aug 15 10:56:41 2001
>
> (c) Copyright 2000 Oracle Corporation. All rights reserved.
>
> SQL> connect system_at_smstdb
> Enter password: ******
> Connected.
> SQL> grant sysdba to pur003;
> grant sysdba to pur003
> *
> ERROR at line 1:
> ORA-01031: insufficient privileges
>
>
> SQL> connect system_at_smstdb as sysdba
> Enter password: ******
> Connected.
> SQL> grant sysdba to pur003;
> grant sysdba to pur003
> *
> ERROR at line 1:
> ORA-01031: insufficient privileges
>
>
> SQL> connect sys_at_smstdb
> Enter password: ******
> Connected.
> SQL> grant sysdba to pur003;
> grant sysdba to pur003
> *
> ERROR at line 1:
> ORA-01031: insufficient privileges
>
>
> SQL> connect sys_at_smstdb as sysdba
> Enter password: ******
> Connected.
> SQL> grant sysdba to pur003;
> grant sysdba to pur003
> *
> ERROR at line 1:
> ORA-01031: insufficient privileges
>
>
> SQL>
>
>
> So . . . what am I missing here?
> --
> Ed Stevens
> (Opinions expressed do not necessarily represent those of my employer.)

1 check the init.ora parameter remote_login_passwordfile It should be set to exclusive to allow other users than internal (exclusive) or sys (shared) to receive sysdba privilege, the default is none, allowing only internal or connect / as sysdba
2 obviously in your current situation only internal will be allowed to grant sysdba.
If you switch to exclusive (and bounce the database) you would still need connect sys as sysdba
It's all in the Oracle Server Administrators manual.

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Wed Aug 15 2001 - 13:12:42 CDT