Explain What are the steps to creating a password authentication file?
Submitted by: AdministratorThe 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
Submitted by: Administrator
* 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
Submitted by: Administrator
Read Online Database Security Oracle Job Interview Questions And Answers
Top Database Security Oracle Questions
☺ | Explain What is Privilege Auditing? |
☺ | Explain How you can secure our data in local area Network? |
☺ | Explain What are roles? How can you implement roles? |
☺ | What are the security features in Oracle? |
☺ | Explain How can we enable automatic archiving? |
Top DB Oracle Categories
☺ | Oracle PL-SQL Interview Questions. |
☺ | Oracle DBA Interview Questions. |
☺ | Oracle D2K Interview Questions. |
☺ | OCI Interview Questions. |
☺ | Forms Reports Interview Questions. |