OraFAQ Forum: Security » password problem in new database

Home » RDBMS Server » Security » password problem in new database

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

password problem in new database [message #546490]

Wed, 07 March 2012 01:44

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.

Report message to a moderator

Re: password problem in new database [message #546491 is a reply to message #546490]

Wed, 07 March 2012 01:50

John Watson
Messages: 8960
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.

Report message to a moderator

Re: password problem in new database [message #546493 is a reply to message #546491]

Wed, 07 March 2012 02:31

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?

Report message to a moderator

Re: password problem in new database [message #546495 is a reply to message #546493]

Wed, 07 March 2012 03:21

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Yes, ORA_DBA group is Windows OSDBA group.

Regards
Michel

Report message to a moderator

Re: password problem in new database [message #546529 is a reply to message #546490]

Wed, 07 March 2012 05:21

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 .

Report message to a moderator

Re: password problem in new database [message #546534 is a reply to message #546529]

Wed, 07 March 2012 05:30

cookiemonster
Messages: 13958
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

Report message to a moderator

Re: password problem in new database [message #546541 is a reply to message #546534]

Wed, 07 March 2012 05:50

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

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.

Report message to a moderator

Previous Topic:	LOST ORACLE 9I'S PASSWORD
Next Topic:	data encryption

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 10:31:37 CST 2024