Creating and Maintaining a Database Password File

You can create a database password file using the password file creation utility, ORAPWD. For some operating systems, you can create this file as part of your standard installation.

infrastructure services

• ORAPWD Syntax and Command Line Argument Descriptions
  The ORAPWD command creates and maintains a password file.
• Creating a Database Password File with ORAPWD
  You can create a database password file with ORAPWD.
• Sharing and Disabling the Database Password File
  You use the initialization parameter REMOTE_LOGIN_PASSWORDFILE to control whether a database password file is shared among multiple Oracle Database instances. You can also use this parameter to disable password file authentication.

it consulting

• Keeping Administrator Passwords Synchronized with the Data Dictionary
  If you change the REMOTE_LOGIN_PASSWORDFILE initialization parameter from none to exclusive or shared, then you must ensure that the passwords stored in the data dictionary and the passwords stored in the password file for the non-SYS administrative users, such as SYSDBA, SYSOPER, SYSBACKUP, SYSDG, and SYSKM users are the same.
• Adding Users to a Database Password File
  When you grant SYSDBA, SYSOPER, SYSBACKUP, SYSDG, or SYSKM administrative privilege to a user, that user’s name and privilege information are added to the database password file.

it support

• Granting and Revoking Administrative Privileges
  Use the GRANT statement to grant administrative privileges. Use the REVOKE statement to revoke administrative privileges.
• Viewing Database Password File Members
  The V$PWFILE_USERS view contains information about users that have been granted administrative privileges.
• Removing a Database Password File
  You can remove a database password file if it is no longer needed.

loyalty