REMOTE_LOGIN_PASSWORDFILE (10.2) _ MySQL

REMOTE_LOGIN_PASSWORDFILE (which controls whether the password file can be used during remote connection) Other {NONE | SHARED} DefaultvalueSHAR REMOTE_LOGIN_PASSWORDFILE (whether the password file can be used during remote connection)

Property	Description
Parameter type	String
Syntax	REMOTE_LOGIN_PASSWORDFILE = {NONE | SHARED}
Default value	SHARED
Modifiable	No
Basic	Yes
Real Application Clusters	Multiple instances must have the same value.

REMOTE_LOGIN_PASSWORDFILE specifies whether Oracle checks for a password file.

Values:

NONE

Oracle ignores any password file. Therefore, privileged users must be authenticated by the operating system. --- that is, users such as sys must log on through the operating system authentication

SHARED

One or more databases can use the password file. The password file can containSYS as well as non-SYS users.

Note:

The value EXCLUSIVE is supported for backward compatibility. It now has the same behavior as the valueSHARED.