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: Security/Accounts in an Oracle development environment

RE: Security/Accounts in an Oracle development environment

From: Paula Stankus <paulastankus_at_yahoo.com>
Date: Thu, 27 Dec 2007 14:11:56 -0800 (PST)
Message-ID: <227168.52145.qm@web33203.mail.mud.yahoo.com>


Okay,    

  Version: Oracle 8i - is it better in 10g???   OS: Solaris    

  This is driving me crazy and I cannot help thinking that SQL Server provides an easier security model.....    

  In our development environment we set up schemas. Those schemas, of course, own all the objects associated with an application in a database.    

  So, to provide read/write access (i.e. the ability to modify objects in that schema) the choices are:    

  A-give that schema usercode/password (what if multiple developers?????) - we appoint an "application dba"    

  B-give that person the ability to create any table, .... or any of the *** any privileges which to me is even worse.    

  Is there an add-on, another option?    

  Thanks,
  Paula        



Looking for last minute shopping deals? Find them fast with Yahoo! Search.
--

http://www.freelists.org/webpage/oracle-l Received on Thu Dec 27 2007 - 16:11:56 CST

Original text of this message

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