RE: Security/Accounts in an Oracle development environment

Just write a short script to grant access on the objects you want to the
users you want. You can do a semi-Cartesian product between dba_users  and
dba_objects filtering as necessary.

 

Ken

 

  _____  

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Paula Stankus
Sent: Thursday, December 27, 2007 5:12 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Security/Accounts in an Oracle development environment

 

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
<http://us.rd.yahoo.com/evt=51734/*http:/tools.search.yahoo.com/newsearch/ca
tegory.php?category=shopping>  them fast with Yahoo! Search.

Other related posts: