What are the steps to creating a password authentication file?

ashokbabugaddipati

 Profile Answers by ashokbabugaddipati Questions by ashokbabugaddipati

• Jun 2nd, 2011

1.set the remote_login_passwordfile='EXCLUSIVE'2.orapwd  file=pwdsid.ora password=xxxxxx  force=ywe have to check the password file is created or not using the following querySQL> select * from v$pwfile_users;

g.mrunalini

 Profile Answers by g.mrunalini Questions by g.mrunalini

• Jul 22nd, 2008

There are two types of authenticationsOS levelDB levelFor OS level authentication:1. Shutdown the database2. Set OS_AUTHENT_PREFIX=' '    in init.ora file3.$ connect  '...

Answer Question  Select Best Answer