| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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).
-- 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).Received on Wed Nov 21 2001 - 10:32:12 CST
 |
 |