OraFAQ Forum: Security » How to connect ws services to the oracle db without password?

Home » RDBMS Server » Security » How to connect ws services to the oracle db without password?

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

How to connect ws services to the oracle db without password? [message #174436]

Mon, 29 May 2006 04:24

smurfcho
Messages: 2
Registered: May 2006
Location: Suisse

Junior Member

Hello,

i have the following problem. I have implement a couple of windows services, which are running at the moment under the windows current user and connect to the oracle9i db with this user name.
I want to make this services running under Lokal system, and connect to the db without user name and password.
How can i do this?

Thanks in advance!
Best regards,
Svetoslav

Report message to a moderator

Re: How to connect ws services to the oracle db without password? [message #174465 is a reply to message #174436]

Mon, 29 May 2006 05:24

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

On VMS operating system, there was a possibility to create Oracle users in such a manner that their username looked like this: "ops$scott" (instead of just "scott"). This meant that you could connect to this Oracle user using only a slash (/) sign.

For example, once logged in on the VMS system, you would simply put it as

$ SQLPLUS /

Scripts were run the same way:

$ sqlplus / -s @some_script

I *believe* this should work elsewhere (not only on VMS); I hope someone will correct me if I'm wrong.

Report message to a moderator

Re: How to connect ws services to the oracle db without password? [message #174521 is a reply to message #174465]

Mon, 29 May 2006 07:54

smurfcho
Messages: 2
Registered: May 2006
Location: Suisse

Junior Member

Hi,

thanks for your tips! At the moment we use exactly the same way to authorize the users.

This what i am trying to do, is to change the running user of the services, which are running now under "windows current user" to "Local system" and to connect then (this services) to the oracle db without user name and password.

Best regards,
Svetoslav

Report message to a moderator

Previous Topic:	Not able to check the SQL statements used by user- need help
Next Topic:	Auditing XML, Extended

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 18 04:08:14 CST 2025