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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Paula Stankus
Sent: Thursday, December 27, 2007 5:12 PM To: oracle-l_at_freelists.org
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.

--
http://www.freelists.org/webpage/oracle-l