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 <[EMAIL PROTECTED]>
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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
