Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Creating DBA Login.

Status
Not open for further replies.

Amit

Programmer
May 30, 1999
2
IN
How do I create a DBA Login in my machine? I want to have all the DBA roles and privileges. I am using Oracle 8 Server on NT 4.0.
 
You don't need to create a dba login, you have two dba users:<br>
sys,system<br>
<br>
They are automatically created and have the dba role. The password from sys is change_on_install , system is manager.<br>

 
You can create a new account in the database (for yourself) and grant a DBA role to that user. <br>
To do this you have to logon as SYS or System to the database.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top