dbTalk Databases Forums  

Oracle Security Question

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss Oracle Security Question in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
amerar@iwc.net
 
Posts: n/a

Default Oracle Security Question - 12-07-2004 , 09:12 AM







Hi All,

I am hving real trouble with this one. Basically I've been asked to
crack down on database security. Everyone knows all the passwords to
all the schemas.

The problem is this place has several Visual Basic applications where
the password is hard coded into the code. This does me no good,
because once I change the password, I need to tell the developer what
it is......it defeats the purpose of changing the password.

What options are available to me? We are running Oracle 8.1.7.3. I
need to hide the passwords from everyone. But I'm not sure what
options I have over a network......

Thanks,

Arthur


Reply With Quote
  #2  
Old   
Bricklen
 
Posts: n/a

Default Re: Oracle Security Question - 12-07-2004 , 09:15 AM






amerar (AT) iwc (DOT) net wrote:
Quote:
Hi All,

I am hving real trouble with this one. Basically I've been asked to
crack down on database security. Everyone knows all the passwords to
all the schemas.

The problem is this place has several Visual Basic applications where
the password is hard coded into the code. This does me no good,
because once I change the password, I need to tell the developer what
it is......it defeats the purpose of changing the password.

What options are available to me? We are running Oracle 8.1.7.3. I
need to hide the passwords from everyone. But I'm not sure what
options I have over a network......

Thanks,

Arthur

An excellent place to start doing your research is here:
http://www.petefinnigan.com/

There is a wealth of information there, some of which I'm sure can get
you pointed in the right direction.


Reply With Quote
  #3  
Old   
Volker Hetzer
 
Posts: n/a

Default Re: Oracle Security Question - 12-07-2004 , 11:50 AM




<amerar (AT) iwc (DOT) net> schrieb im Newsbeitrag news:1102432338.770876.210810 (AT) f14g2000cwb (DOT) googlegroups.com...
Quote:
Hi All,

I am hving real trouble with this one. Basically I've been asked to
crack down on database security. Everyone knows all the passwords to
all the schemas.
So, change them and tell users their own passwords.

Quote:
The problem is this place has several Visual Basic applications where
the password is hard coded into the code. This does me no good,
because once I change the password, I need to tell the developer what
it is......it defeats the purpose of changing the password.
Who asked you to crack down on security? Tell thay guy that the passwords
have to go from the apps. Users have to type them in each time they log on.

Quote:
What options are available to me? We are running Oracle 8.1.7.3. I
need to hide the passwords from everyone. But I'm not sure what
options I have over a network......
Can you access an LDAP server?

Lots of Greetings!
Volker


Reply With Quote
  #4  
Old   
amerar@iwc.net
 
Posts: n/a

Default Re: Oracle Security Question - 12-09-2004 , 11:20 AM




Volker Hetzer wrote:
Quote:
amerar (AT) iwc (DOT) net> schrieb im Newsbeitrag
news:1102432338.770876.210810 (AT) f14g2000cwb (DOT) googlegroups.com...

Hi All,

I am hving real trouble with this one. Basically I've been asked
to
crack down on database security. Everyone knows all the passwords
to
all the schemas.
So, change them and tell users their own passwords.


The problem is this place has several Visual Basic applications
where
the password is hard coded into the code. This does me no good,
because once I change the password, I need to tell the developer
what
it is......it defeats the purpose of changing the password.
Who asked you to crack down on security? Tell thay guy that the
passwords
have to go from the apps. Users have to type them in each time they
log on.


What options are available to me? We are running Oracle 8.1.7.3.
I
need to hide the passwords from everyone. But I'm not sure what
options I have over a network......
Can you access an LDAP server?

Lots of Greetings!
Volker
This issue here is that the developers know the password, and go into
production and change stuff. If I tell the developer what the password
is, it defeats the purpose of changing the password.

However, I like the idea of hiding it in the registry. That can open
up several possibilities.

Arthur



Reply With Quote
  #5  
Old   
DA Morgan
 
Posts: n/a

Default Re: Oracle Security Question - 12-09-2004 , 04:24 PM



amerar (AT) iwc (DOT) net wrote:

Quote:
Volker Hetzer wrote:

amerar (AT) iwc (DOT) net> schrieb im Newsbeitrag

news:1102432338.770876.210810 (AT) f14g2000cwb (DOT) googlegroups.com...

Hi All,

I am hving real trouble with this one. Basically I've been asked

to

crack down on database security. Everyone knows all the passwords

to

all the schemas.

So, change them and tell users their own passwords.


The problem is this place has several Visual Basic applications

where

the password is hard coded into the code. This does me no good,
because once I change the password, I need to tell the developer

what

it is......it defeats the purpose of changing the password.

Who asked you to crack down on security? Tell thay guy that the

passwords

have to go from the apps. Users have to type them in each time they

log on.

What options are available to me? We are running Oracle 8.1.7.3.

I

need to hide the passwords from everyone. But I'm not sure what
options I have over a network......

Can you access an LDAP server?

Lots of Greetings!
Volker


This issue here is that the developers know the password, and go into
production and change stuff. If I tell the developer what the password
is, it defeats the purpose of changing the password.

However, I like the idea of hiding it in the registry. That can open
up several possibilities.

Arthur
One solution to developers going into production is to exclude them
using EXCLUDED NODES. Another is a log on trigger and a threat from
management to replace them if they ever log onto production. The later
is remarkably effective if serious.

--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)


Reply With Quote
  #6  
Old   
Volker Hetzer
 
Posts: n/a

Default Re: Oracle Security Question - 12-10-2004 , 04:13 AM




<amerar (AT) iwc (DOT) net> schrieb im Newsbeitrag news:1102612813.056970.16540 (AT) c13g2000cwb (DOT) googlegroups.com...
Quote:
Volker Hetzer wrote:
amerar (AT) iwc (DOT) net> schrieb im Newsbeitrag
news:1102432338.770876.210810 (AT) f14g2000cwb (DOT) googlegroups.com...

Hi All,

I am hving real trouble with this one. Basically I've been asked
to
crack down on database security. Everyone knows all the passwords
to
all the schemas.
So, change them and tell users their own passwords.


The problem is this place has several Visual Basic applications
where
the password is hard coded into the code. This does me no good,
because once I change the password, I need to tell the developer
what
it is......it defeats the purpose of changing the password.
Who asked you to crack down on security? Tell thay guy that the
passwords
have to go from the apps. Users have to type them in each time they
log on.


What options are available to me? We are running Oracle 8.1.7.3.
I
need to hide the passwords from everyone. But I'm not sure what
options I have over a network......
Can you access an LDAP server?

Lots of Greetings!
Volker

This issue here is that the developers know the password, and go into
production and change stuff. If I tell the developer what the password
is, it defeats the purpose of changing the password.
Yes, that's why the app ought to be changed so that the user has to type
in the password. Then the developers won't know it. Doing a proper
password management is the only solution that works in the long term.


Lots of Greetings!
Volker


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.