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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
Via a live example, show how to take different types of Oracle backups using RMAN.
Suggested Courses

801 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