Re: grant SYSDBA to user With remote_login_passwordfile=NONE?

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