Tuesday, July 04, 2006
Password authentication setup: OS v/s password file
Operating system authentication setup:
Create NT user-group : ORA_SID_DBA, ORA_SID_OPER specific to an instance SID
Create NT user-group : ORA_DBA, ORA_OPER not specific to an instance
Add a NT OS user to that group. Once you access this domain you will automatically be
validated as an authorized DBA.
sqlnet.ora parameter setting : SQLNET.AUTHENTICATION_SERVICES=(NTS)
init.ora parameter setting : REMOTE_LOGIN_PASSWORDFILE=NONE
REMOTE_LOGIN_PASSWORDFILE allowed values:
Note : Any object created by anyone logging in as SYSOPER or SYSDBA will be owned by SYS.
Password file authentication setup:
Create a password file through ORAPWD utility:
In NT :
C:\ > orapwd FILE='%ORACLE_HOME%\database\orapwSKDB.pwd' PASSWORD=jason ENTRIES=5
orapwd \FILE='/u01/app/oracle/product/9.0.1/dbs/orapwSKDB.pwd' \PASSWORD=jason
Password assigned to the pwd file will automatically set the same for the SYS user to login Oracle.
The password for this file & user SYS is the same.
Entries sets the maximum number of user entries for the password file. To add more later, the
password will need to be deleted & re-created, which is risky. So exercise due care while deciding.
init.ora parameter setting : REMOTE_LOGIN_PASSWORDFILE=exclusive
To view users in the database password file : V$PWFILE_USERS
| || |
well past midnight now... In the background of my brains i can almost hear her say these words...
tu hi meri shaab bai... subah hai... tu hi din hai mera...
tu hi mera raab hai... jahan hai... tu hi meri duniya... tu waqt mere liye, mei hu tera lamha...
kaisi rahega bhala... tu mujhse jooda..
crazy & maddening... memories overpowering...
[Gangster movie song (translation) : u r my night... morning... day..., u r my God... my world... universe...
You are my time and i am ur moment... how will u live without me?]
| || |