OraFAQ Forum: Server Administration » Oracle did not ask for username/passwd to get connected.

Home » RDBMS Server » Server Administration » Oracle did not ask for username/passwd to get connected. (10.1.0.5.0/Win2003 server)

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

Oracle did not ask for username/passwd to get connected. [message #306694]

Sat, 15 March 2008 22:10

it_me24
Messages: 167
Registered: March 2006
Location: delhi

Senior Member

Hello Everybody,

I have recently created a Database, and while connecting as SYS DBA i do not need to provide a password because the user is a member of ORA DBA.

I want oracle to ask for the username and password to get connected.

I tried creating a password file but got an error.

SQL> $orapwd file='F:\oracle\product\10.2.0\db_5\dbs' password=test123! entries=5

OPW-00001: Unable to open password-file

so,I removed the user from the ORA-DBA group, by that way oracle did ask for the user and password, since this way any body using the OS Aadministrator account can add/remove the member from ORA-DBA group.

Is there any other way to accomplish the task?

Please Suggest!!

Thanks for your time.

Report message to a moderator

Re: Oracle did not ask for username/passwd to get connected. [message #306695 is a reply to message #306694]

Sat, 15 March 2008 22:14

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Is there any other way to accomplish the task?
What "task"?

What problem are you trying to solve?
How would an independent observer conclude (or not) the problem has really been solved (or not)?
What is the quantifiable metric for success & failure?

Report message to a moderator

Re: Oracle did not ask for username/passwd to get connected. [message #306696 is a reply to message #306694]

Sat, 15 March 2008 22:31

it_me24
Messages: 167
Registered: March 2006
Location: delhi

Senior Member

Thankyou so much for your reply.

My appologies.

I do not want use connect / as sysdba login method.
I wish oracle to ask for the username and password before login even if i have the OS administrative privs.

I can do it if i remove the user from the OS(ORACLE DBA) group.
but i want security at oracle level.

How do i force users including me to provide username and password to connect to the oracle?
if through password file, then how to check wheather password file is already created or not.

thanks

Report message to a moderator

Re: Oracle did not ask for username/passwd to get connected. [message #306698 is a reply to message #306694]

Sat, 15 March 2008 22:52

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://download.oracle.com/docs/cd/B19306_01/network.102/b14266/toc.htm

You can't get there.

Only TRUSTED users should have logon access to the database server as a member of the "dba" group.

Otherwise, when the "dba password" becomes lost, you'd be locked out of the database permanently!

Accessing the database via
/ as sysdba
is the "master key" when all other means fails to gain access.

Report message to a moderator

Re: Oracle did not ask for username/passwd to get connected. [message #306701 is a reply to message #306694]

Sat, 15 March 2008 23:18

it_me24
Messages: 167
Registered: March 2006
Location: delhi

Senior Member

Thanks for your replies.

I have one more query.
I want to create a user which will only run the scheduled job like

execute DBMS_SNAPSHOT.REFRESH('orcl10.ACCOUNT','F');

Which privilege should i assingn the user.

thanks

Report message to a moderator

Re: Oracle did not ask for username/passwd to get connected. [message #306702 is a reply to message #306694]

Sat, 15 March 2008 23:27

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>execute DBMS_SNAPSHOT.REFRESH('orcl10.ACCOUNT','F');

>Which privilege should i assingn the user.
Privs acquired via ROLE do NOT apply with PL/SQL procedures.

At a minimum

GRANT EXECUTE on DBMS_SNAPSHOT to DESIGNATED_USER.

Report message to a moderator

Previous Topic:	Oracle 9i and 10g...difference from DB Administration and Developing View
Next Topic:	Database creation errors

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 04:04:22 CST 2024