SQL - How to change administrator password of DB and creation of normal user

Hi, Check this out here.

    MSSQL - SA  (Administrator)
    Oracle OEE - SYS, SYSTEM  (SYSDBA)
 
To change sys password of OEE:
1. Change the sqlnet.ora
sqlnet.authentication_services = NTS
2. Restart OEE service,
3. In command prompt, sqlplus / as sysdba;
Alter user sys identified by "password" ;

4.To test the changed password, sqlplus sys/"pasword"@DBname as sysdba;


To create normal user :
1. In cmd,  sqlplus sys/"pasword"@DBname as sysdba;
2. Create user smyeong identified by "password";
3. grant connect, resource to smyeong;
4. grant dba,resource to smyeong;

Hope that helps....