Answers

Question and Answer:

  Home  Database Security

⟩ Explain What are the steps to creating a password authentication file?

The steps are :

* First set REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE in init.ora file

* Then dbs$orapwd file=orapw$ORACLE_SID password=sys force=y

* Then startup force;

* Then grant sysdba to user(any user in the database);

* Then conn user/user

* Then conn user/user as sysdba

* Then show user

 162 views

More Questions for you: