Re: grant SYSDBA to user With remote_login_passwordfile=NONE?

thank you! that answers my question perfectly.

my confusion arose because there are 3 instances running on our machine (RS6000, AIX).. two instances have remote_login_passwordfile=EXCLUSIVE and in these instances, user SYS
has the SYSDBA System privilege (as seen in the Oracle DBA Studio Management Interface)

the other instance has remote_login_passwordfile=NONE and user SYS does not have the SYSDBA
System Privilege, in fact no visible user does. The 'internal' login ID (if it can be called that) does not appear in the DBA studio user manager.

i had already determined that i could use svrmgrl to 'connect internal' (as SYSDBA),
but trying to 'grant SYSDBA to user SYS' failed - now i know why.

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:k6tp719ijh7oi1uu8u9bgnnipgm6ukq65s_at_4ax.com...
> On Sat, 7 May 2005 11:24:50 -0400, "Luis Correia"
> <llcorreia_at_yahoo.com> wrote:
>
>>hello..
>>
>>with oracle 7.3.4.4 and with remote_login_passwordfile=NONE,
>>can a user be granted the SYSDBA system privilege?
>>
>>Or does granting the SYSDBA system privilege imply that a password file
>>must
>>be used.
>>
>
> To your question: no. Did you try?
>
>
> remote_login_passwordfile = none ---> only internal has SYSDBA
> remote_login_passwordfile = shared ---> only internal and SYS have
> SYSDBA
> remote_login_passwordfile = exclusive ---> any user can get SYSDBA
> privilege.
>
>
> --
> Sybrand Bakker, Senior Oracle DBA
Received on Sat May 07 2005 - 14:35:38 CDT