Tuesday, June 10, 2014

SQLNET.AUTHENTICATION_SERVICES

SQLNET.AUTHENTICATION_SERVICES

Use the parameter SQLNET.AUTHENTICATION_SERVICES to enable one or more authentication services.
If authentication has been installed, it is recommended that this parameter be set to either none or to one of the authentication methods.

Default value is null
None
none for no authentication methods. A valid username and password can be used to access the database.


ALL
all for all authentication methods


NTS
SQLNET.AUTHENTICATION_SERVICES= (NTS) It allows Windows users to be authenticated using Windows NT native security.

To connect sys user as "/ as sysdba", we need to add current machine user in "ora_dba" group. by doing with we can connect sys user with supplying the password.

No comments:

Post a Comment

web stats