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 Rhinorhino 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
Joined
May 30, 1999
Messages
2
Location
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