Re: REMOTE_LOGIN_PASSWORDFILE parameter

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 9 Jul 2001 19:22:27 +0200
Message-ID: <tkjpuikg66hmf1@beta-news.demon.nl>

"K. C." <the_ada_at_hotmail.com> wrote in message news:be879ba7.0107081416.34ee880a_at_posting.google.com...
> Hi,
>
> Could someone tell me what the REMOTE_LOGIN_PASSWORDFILE parameter is
> for? Someone said I should set it to SHARED (the default is
> EXCLUSIVE) and after I did that, I can't create users with DBA
> privileges anymore.
>
> Please help!! Thanks!!

This parameter deals with privileged (SYSDBA or SYSOPER) access. If the parameter is NONE (which is, sorry to say so, the default), SYSDBA/SYSOPER access is only available on the server hosting the database by issuing connect / as sysdba.

If set to SHARED, SYS will also have SYSDBA access, so connect SYS/password as SYSDBA can be issued from *any* workstation in the network. Additional users are *not* possible.

If set to exclusive, SYSDBA/SYSOPER privilege can be granted to *any* user in the database, and they again can connect from any workstation in this fashion.

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Mon Jul 09 2001 - 12:22:27 CDT