Re: [help] Oracle privilege

In article <1994Jun30.065111.1_at_corp02.d51.lilly.com>, jl34778_at_corp02.d51.lilly.com wrote:

> In article <2uel3n$npm_at_ucunix.san.uc.edu>, daoad_at_ucunix.san.uc.edu (Andrew) writes:
> > I don't understand why users have only connection privilege CAN
> > create tables on our Oracle database. Please tell me what I need
> > to configure our Oracle database to work properly.
> >
> > We are using ORACLE RDBMS V6.2.6.3. on VAX/VMS V6.1
> >
> > Thanks in advance.
> > -- andrew
> > ~
>
> One possibility is that you have granted RESOURCE on their default tablespace
> to PUBLIC. This is something that you can do in ORACLE6, but not ORACLE7.
>
> --
> Bob Swisshelm | swisshelm_at_Lilly.com | 317 276 5472
> Eli Lilly and Company | Lilly Corporate Center | Indianapolis, IN 46285

An other possibility can you find in the Oracle7 Server / SQL Language Reference Manual on p. 4-308 table 4-12 (roles defined by ORACLE)

Role        System Privileges and Roles Granted
CONNECT     ALTER SESSION
            CREATE CLUSTER
            CREATE DATABASE LINK
            CREATE SEQUENCE
            CREATE SESSION
            CREATE SYNONYM
            CREATE TABLE
            CREATE VIEW

Now the question is: Is this a documentation bug or not (as the CREATE CLUSTER and CREATE TABLE role are also mentioned with the role RESOURCE)
But then the user still needs a quota on a tablespace.

-- 
Leo Mannhart
Planning Office
University of Zurich               phone: ++41 1 257 23 34
Kuenstlergasse 15                    fax: ++41 1 257 22 12
CH-8001 Zurich, Switzerland        eMail: mannhart_at_zuv.unizh.ch