Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Smart Client Application and Oracle Security

Re: Smart Client Application and Oracle Security

From: Dennis Williams <oracledba.williams_at_gmail.com>
Date: Fri, 27 Apr 2007 10:42:50 -0500
Message-ID: <de807caa0704270842s5048248w74e835d002d6add4@mail.gmail.com>


Jordan,

Hopefully you'll get some expert replies. In the meantime, I have a simple suggestion.
Have one username for your schema owner. This schema owns all the application's objects.
Use other usernames for access. This simple strategy allows you to increase security in a number of ways. When every access method uses the same username, then you can't change the password without telling it again to everyone. If each access method (clients, report viewers, etc.) use different usernames, then when you have a runaway process you can track it to the source more quickly.

Dennis Williams

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Apr 27 2007 - 10:42:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US