yeah that would work too :)
--- [EMAIL PROTECTED] 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 <[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). __________________________________________________ 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).
