DBA studio logon with mandatory user/password as sysdba

Posted on 2005-03-05
Medium Priority
Last Modified: 2012-06-27
i m using ORACLE 8i in windows 2k environment

i m loged on in windows as administrator. when i use DBA studio, i connect as SYSDBA without entering username ans password

can it be retricted, to must accept username and password
and does not logon without user and password?

help pl.

Question by:Fayyaz
LVL 25

Expert Comment

ID: 13469339
Database Server Windows Group Authentication
When you install Oracle on a Windows server, the system creates an ORA_DBA Windows group and automatically adds to that group the Windows account used to install Oracle. The DBA can then add to the group other Windows users who need full Oracle DBA privileges. But be careful—Windows local and domain users within the ORA_DBA group don't have to supply an Oracle username and password. As the Description property for the ORA_DBA group says, Members can connect to the Oracle database as a DBA without a password.

1) Choose Start > Programs > Oracle - HOME_NAME > Configuration and Migration Tools > Administration Assistant for Windows NT.
2) Oracle Administration Assistant for Windows NT starts.
3) Right-click OS Database Administrators - Computer.
4) Choose Add/Remove.
5) The OS Database Administrators - Computer for hostname dialog appears.

You can remove the users here.
LVL 13

Accepted Solution

anand_2000v earned 150 total points
ID: 13470079
1) remove all users from the OS group ORA_DBA
2) in sqlnet.ora comment any line which starts as
put a # in front of the line
3) change your init file
4) use the command
orpwd file=<oracle_home>\database\pwd<sid>.ora password=<password>
<oracle_home> - is where oracle is installed. it might be c:\oracle\ora90 or something like that based upon the version you have installed. use windoze explorer to verify that
<sid> - is your database service identifier. by default it id orcl
<password> - whatever password you want to set

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

609 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question