How To Create an Oracle Password File

dbtut

6 years ago

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.

GRANT SYSDBA TO username;
REVOKE SYSDBA FROM username;

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.

Select * FROM V$PWFILE_USERS;

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.

orapwd FILE=orapassfile ENTRIES=10

1	orapwd FILE=orapassfile ENTRIES=10