Re: Minimal privileges to create a table

From: Lyall Barbour <lbarbour_at_stanford.edu>
Date: Tue, 15 Aug 2000 10:10:29 -0700
Message-Id: <10590.114626@fatcity.com>

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).
Received on Tue Aug 15 2000 - 12:10:29 CDT