Re: Developer access in test database

Hello Dennis

To answer your question:
We define schema owner for each application and only the DBA knows the password. the user gets i, u, d, s grants on the objects but have NO grants to do DLL's. All DDL is done by the DBA.

This role was implemented after tables began to disappear from the schema due to the use of tools that did things on their own.

Sure, it is more work for the DBA but it is better the restoring DB or restoring
tables from export while the entire team sits around drinking coffee.

Yechiel Adar
Mehish

• Original Message ----- To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Saturday, April 13, 2002 3:53 PM

> There is one issue nobody has mentioned yet. How about developers creating
> their own tables in their own schema, creating their code, then presenting
> the finished product as fait accompli? Or in the review saying "I'll
gladly
> explain why I did it this way". We are on the brink of some large
> development projects, so this issue is very relevant.
> Dennis Williams
> DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
>
> -----Original Message-----
> Sent: Friday, April 12, 2002 2:28 PM
> To: Multiple recipients of list ORACLE-L
>
>
>
> Guess I should clarify... developers only get access to dev, and for
> test & prod they get nothing. I've encountered very few with a
> need/desire for select_catalog_role, and they have to ask first :)
>
> John Hallas wrote:
> >
> > Suzy,
> > You are much too generous.
> > I always have found that asking for a change control form delays things
by
> a
> > few days!!!!!!
> > John
> >
> > -----Original Message-----
> > Sent: 12 April 2002 18:43
> > To: Multiple recipients of list ORACLE-L
> >
> > I generally give developers access only to the schema's they are
> > developing for. In some cases, they might also get select_catalog_role.
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Suzy Vordos
> > INET: lvordos_at_qwest.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: John Hallas
> > INET: john.hallas_at_hcresources.co.uk
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Suzy Vordos
> INET: lvordos_at_qwest.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.COM
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Yechiel Adar
  INET: adaryechiel_at_hotmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).