RE: Privileges by session

  • From: "Blanchard, William" <wblanchard@xxxxxxxxxxxxxxxxxxxx>
  • To: "Jared Still" <jkstill@xxxxxxxxx>
  • Date: Thu, 7 Jan 2010 16:03:51 -0600



From: Jared Still [mailto:jkstill@xxxxxxxxx] 
Sent: Thursday, January 07, 2010 4:02 PM
To: Blanchard, William
Cc: Michael Fontana; oracle-l@xxxxxxxxxxxxx
Subject: Re: Privileges by session

On Thu, Jan 7, 2010 at 1:59 PM, Blanchard, William
<wblanchard@xxxxxxxxxxxxxxxxxxxx> wrote:

        That's the conundrum.  They know the application passwords,
there's no
        way around it.  I need to lock them down to a read only session
        they log on from sqlplus, SQL Developer, Toad, etc.

If I understand correctly, the passwords are hardcoded in to the app,
and therefore
dev and prod environments use the same password.

Is that correct?

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog:
Home Page:

Other related posts: