Home » RDBMS Server » Security » password problem in new database
password problem in new database [message #546490] Wed, 07 March 2012 01:44 Go to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
hello friends,
i have created a database on my pc and i have given a password at the time of installation , after the installation it is accessed successfully by the given password , but i observed that when i gave anything in password then it is also accessed by it and i dont have any other database of this same name.why this is happening please tell me. thanx in advance to all
and when i access it through another system then it is accessed only by its original password not by any other password.
Re: password problem in new database [message #546491 is a reply to message #546490] Wed, 07 March 2012 01:50 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
If you are logged on to your operating system as a member of the OSDBA group, then it doesn't matter what password you give: the Operating System will authenticate you.
Re: password problem in new database [message #546493 is a reply to message #546491] Wed, 07 March 2012 02:31 Go to previous messageGo to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
thank u very much sir,
but my a user by which i am log in as a member of the ora_dba and i am using windows server2008 os not unix(so not a member of osdba,i think). is it because of ora_dba?
Re: password problem in new database [message #546495 is a reply to message #546493] Wed, 07 March 2012 03:21 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, ORA_DBA group is Windows OSDBA group.

Regards
Michel
Re: password problem in new database [message #546529 is a reply to message #546490] Wed, 07 March 2012 05:21 Go to previous messageGo to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
thanx michel,
but sir there is no osdba group on my pc only ora_dba group.
control panel>administrator tools>computer management>local users or group



is both are same? i am using windows server2008 and oracle 11.2.0.1.0 .
Re: password problem in new database [message #546534 is a reply to message #546529] Wed, 07 March 2012 05:30 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
Michel's saying that the windows group ORA_DBA is the same as the unix group OSDBA
Re: password problem in new database [message #546541 is a reply to message #546534] Wed, 07 March 2012 05:50 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
... and OSDBA is a generic term for Oracle to name the OS group that allows you to connect as SYSDBA and which is ORA_DBA on Windows and is most often (but is not mandatory) "dba" on *nix.

In addition, ORA_<SID>_DBA group allows you to connect as SYSDBA on instance <SID> and ORA_DBA one allows you to connect as SYSDBA on any instance (of the server).

Regards
Michel

[Edit: forgot a word]

[Updated on: Wed, 07 March 2012 06:34]

Report message to a moderator

Re: password problem in new database [message #546557 is a reply to message #546541] Wed, 07 March 2012 06:33 Go to previous message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
thnak u very much michel and cookiemonster,
i have understand it. thanx once again sir.
Previous Topic: LOST ORACLE 9I'S PASSWORD
Next Topic: data encryption
Goto Forum:
  


Current Time: Thu Mar 28 03:38:19 CDT 2024