Home » RDBMS Server » Security » Problem with SYSDBA login credentials
icon5.gif  Problem with SYSDBA login credentials [message #286624] Sun, 09 December 2007 02:19 Go to next message
saratchaitanya
Messages: 7
Registered: September 2007
Junior Member
Hello Everyone...
I'm using Oracle 9i as stated...
The problem is when i type:

conn as sysdba
username:
password:

Its accepting any username and password and displaying "Connected".
And all the administrator rights are being given to the user.
This scenario provides no security for my DB...
Please help me get a secured connection for DBA login...
Thanx in advance...

Sarat.
Re: Problem with SYSDBA login credentials [message #286625 is a reply to message #286624] Sun, 09 December 2007 02:26 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

set NONE in sqlnet.ora file instead of NTS.
or
remove OS user from ORA_DBA group.
Re: Problem with SYSDBA login credentials [message #286637 is a reply to message #286625] Sun, 09 December 2007 03:51 Go to previous messageGo to next message
saratchaitanya
Messages: 7
Registered: September 2007
Junior Member
Thank u for yo immediate response...
But where do i find this ORA_DBA group...
please put it up in detail...
and 1 more doubt ..how ,where and when do we create the SYSDBA username and password...
I mean do v do tht at the time of installation?
Please reply A.S.A.P...


Thank You
Sarat
Re: Problem with SYSDBA login credentials [message #286638 is a reply to message #286637] Sun, 09 December 2007 04:08 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

What do you mean by A.S.A.P?
Re: Problem with SYSDBA login credentials [message #286641 is a reply to message #286638] Sun, 09 December 2007 04:14 Go to previous messageGo to next message
saratchaitanya
Messages: 7
Registered: September 2007
Junior Member
As Soon As Possible....
Any ways...I found where ORA_DBA group is present...
But how to create login for sysdba?
Re: Problem with SYSDBA login credentials [message #286642 is a reply to message #286637] Sun, 09 December 2007 04:17 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA_DBA group is an OS group, you'll find it with user management tool.
SYSDBA password is often given when service is created with oradim or with dbca if you used this tool to create the database.

Read and follow OraFAQ Forum Guide, especially what is said about IM speak and expressions like "urgent" or "as soon as possible".

Regards
Michel

[Updated on: Sun, 09 December 2007 04:44]

Report message to a moderator

Re: Problem with SYSDBA login credentials [message #286643 is a reply to message #286642] Sun, 09 December 2007 04:26 Go to previous message
saratchaitanya
Messages: 7
Registered: September 2007
Junior Member
Sorry about A.S.A.P.....I dint know the rules
Thank you for your reply...
thanks a lott..!!
Previous Topic: find user failed to connect to datadbse
Next Topic: ORA-00904: invalid identifier on table audited with dbms_fga policy
Goto Forum:
  


Current Time: Thu Mar 28 07:15:05 CDT 2024