| |
GeekInterview.com > Interview Questions > Oracle > Backup and Recovery
| Print | |
Question: Authentication Methods for DBAs
Answer: What are the steps to creating a password authentication file? |
| July 07, 2008 05:21:20 |
#1 |
| g.mrunalini |
Member Since: February 2008 Total Comments: 8 |
RE: Authentication Methods for DBAs
|
There are two types of authentications
OS level
DB level
For OS level authentication:
1. Shutdown the database
2. Set OS_AUTHENT_PREFIX=' ' in init.ora file
3.$ connect '/ as sysdba'
4. > startup
5.> create user username(OS level userid created by admin) identified externally;
6.>grant connect, resource to username;
7.dbs$ sqlplus /
8. $username connect / as sysdba
9. startup force
For DB level authentication:
1. set REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE in init.ora file
2. dbs$orapwd file=orapw$ORACLE_SID password=sys force=y
3. startup force;
4. grant sysdba to user(any user in the database);
5. conn user/user
6. conn user/user as sysdba
7. sho user |
| |
Back To Question | |
