Preparing to Use Password File Authentication

crm

To prepare for password file authentication, you must create the password file, set the REMOTE_LOGIN_PASSWORDFILE initialization parameter, and grant privileges.

cyber security

To enable authentication of an administrative user using password file authentication, you must do the following:

data analytics

1. If it is not already created, then create the password file using the ORAPWD utility: orapwd FILE=filename FORMAT=12.2
2. Set the REMOTE_LOGIN_PASSWORDFILE initialization parameter to exclusive. (This is the default).Connect to the database as user SYS (or as another user with the administrative privileges).
3. If the user does not already exist in the database, then create the user and assign a password. Keep in mind that database passwords are case-sensitive.
4. Grant the SYSDBA, SYSOPER, SYSBACKUP, SYSDG, or SYSKM administrative privilege to the user. For example: GRANT SYSDBA to mydba;

digital transformation