RE: Re[2]: Index File Name

That's precisely what I do..
I have *_user and <schema_owner>_developer role with just what they need. No more. No less. However, certain developers will have direct access to tables for coding stored procedures, but those are very limited in number. Standard ksh script to add these users to the database, accepting userid, password, roles etc. So the backup DBA can do this when I am out.

• Kirti

> -----Original Message-----
> From: dgoulet_at_vicr.com [SMTP:dgoulet_at_vicr.com]
> Sent: Wednesday, November 21, 2001 10:04 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re[2]: Index File Name
>
> Rachel,
>
> I create a role called 'developer' in each instance at create time.
> Make it
> look something like resource, but without the unlimited tablespace priv,
> and use
> it in place of resource. saves a step.
>
> Dick Goulet
>
> ____________________Reply Separator____________________
> Author: Rachel Carmichael <wisernet100_at_yahoo.com>
> Date: 11/21/2001 7:45 AM
>
> standard create user script for a user who will own objects:
>
> create user <xyz> identifed by <abc>
> default tablespace <default>
> temporary tablespace <temp>
> quota unlimited on <default>
> /
> grant connect, resource to <xyz>
> /
> revoke unlimited tablespace from <xyz>
> /
>
>
> I've gotten this drilled into my people's heads....... and I check up
> on it :)
> --- Stephane Faroult <sfaroult_at_oriole.com> wrote:
> > Mark Leith wrote:
> > >
> > > And just to add to that - make sure that the user has the
> > appropriate
> > > privileges on the system, such as CREATE TABLE / INDEX, or the role
> > RESOURCE
> > > or whatever.. :)
> > >
> > > Just to nitpick :)
> > >
> >
> > NEVER give RESOURCE ! UNLIMITED TABLESPACE comes with it (even if you
> > cannot grant it to a role, usually - but Oracle 5 compatibility has
> > its
> > reasons ...). Not that I am paranoid, but the idea of users being
> > able
> > to create their tables in SYSTEM makes me nervous.
> > I know, someone should tell to the Oracle folks who prepare demo
> > scripts ...
> > --
> > Regards,
> >
> > Stephane Faroult
> > Oriole Corporation
> > Voice: +44 (0) 7050-696-269
> > Fax: +44 (0) 7050-696-449
> > Performance Tools & Free Scripts
> > --------------------------------------------------------------
> > http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
> > --------------------------------------------------------------
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Stephane Faroult
> > INET: sfaroult_at_oriole.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).
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
> http://geocities.yahoo.com/ps/info1
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rachel Carmichael
> INET: wisernet100_at_yahoo.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:
> INET: dgoulet_at_vicr.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: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.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).