Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
The Oracle password file is a file that is created automatically during installation.
Users defined in this file can connect to oracle via sqlplus without entering a password.
To add users to this file, you must give the sysdba permission to a user.
You can give or revoke the sysdba permission to the users with the help of the following script.
1 2 | GRANT SYSDBA TO username; REVOKE SYSDBA FROM username; |
You can learn which users are defined in this file by using the following script.
1 | Select * FROM V$PWFILE_USERS; |
In the following command, we create an oracle password file named orapassfile .
In this file you will be able to define 10 users.
You can find the file in the $ORACLE_HOME/dbs directory.
1 | orapwd FILE=orapassfile ENTRIES=10 |
