yeah that would work too :)
- dgoulet_at_vicr.com wrote:
> 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____________________
> Subject: Re: Index File Name
> 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).
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).
Received on Wed Nov 21 2001 - 11:21:29 CST