Re: Minimal privileges to create a table

Lyall, within the oracle source code, unlimited tablespace is granted when resource ius granted, since you cant grant that sys priv to a role, they hardcoded it in the source code(anyone @oracle.com want to dispute it??) :)

joe
Lyall Barbour wrote:
>
> From what I can see in 7.3.4, RESOURCE only gives you CREATE
> TABLE. Nothing about UNLIMITED TABLESPACE.
> Does it change in 8 and 8i, Rachel?
>
> Lyall Barbour
>
> At 12:37 PM 8/15/00 -0800, you wrote:
> >resource effectively gives you both of those
> >
> >
> >
> >>From: Lyall Barbour <lbarbour_at_stanford.edu>
> >>Reply-To: ORACLE-L_at_fatcity.com
> >>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >>Subject: Re: Minimal privileges to create a table
> >>Date: Tue, 15 Aug 2000 10:26:07 -0800
> >>
> >>You need CREATE TABLE system privilege. Plus you need quota on the
> >>tablespace the table is being created in.
> >>
> >>Lyall Barbour
> >>
> >>At 08:26 AM 8/15/00 -0800, you wrote:
> >>>What are the minimal privileges required to create a table
> >>>
> >>>I have a user with resource privilege but when I try to create after
> >>>connecting as that user a table I get "insufficient privileges"
> >>>
> >>>John
> >>>
> >>>
> >>>
> >>>
> >>>--
> >>>Author: John Dunn
> >>> INET: john.dunn_at_sefas.co.uk
> >>>
> >>>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).
> >>
> >>--
> >>Author: Lyall Barbour
> >> INET: lbarbour_at_stanford.edu
> >>
> >>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).
> >
> >________________________________________________________________________
> >Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
> >
> >--
> >Author: Rachel Carmichael
> > INET: carmichr_at_hotmail.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).
>
> --
> Author: Lyall Barbour
> INET: lbarbour_at_stanford.edu
>
> 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).

-- 
Joe Testa  http://www.oracle-dba.com