RE: Security/Accounts in an Oracle development environment

From: Paula Stankus <paulastankus@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Thu, 27 Dec 2007 14:11:56 -0800 (PST)

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.

Follow-Ups:

RE: Security/Accounts in an Oracle development environment
From: Rich Jesse

RE: Security/Accounts in an Oracle development environment
From: Ken Naim

References:
- Re: Any reference about use of CSS in Non-RAC ASM instance,
  - From: Dan Norris

RE: Security/Accounts in an Oracle development environment

Other related posts: