From: Dave Eason <flying.pigs@btinternet.com>
Subject: Re: Stopping user access to system tablespace
Date: 2000/07/07
Message-ID: <3965C4D3.7E85D931@btinternet.com>#1/1
Content-Transfer-Encoding: 7bit
References: <8k34i6$m5o$1@nnrp1.deja.com>
X-Accept-Language: en
Content-Type: text/plain; charset=us-ascii
X-Complaints-To: postmaster@axion.bt.co.uk
X-Trace: pheidippides.axion.bt.co.uk 962970886 20979 10.244.64.123 (7 Jul 2000 11:54:46 GMT)
Organization: Whos organized?
Mime-Version: 1.0
NNTP-Posting-Date: 7 Jul 2000 11:54:46 GMT
Newsgroups: comp.databases.oracle.server


Gordy wrote:
> 
> I want to stop all "normal" users from creating objects
> in the system tablespace but I can't seems to stop it
> happening.
> 
> I have set their quota on the system tablespace to zero,
> default tablespaces to user, granted them only connect,
> resource and create sesssion roles.
> 
> Is there something else I can try?
> 
> Cheers
> Gordy
> ICQ 3290116
> http://www.geocities.com/Area51/Cavern/4253
> 
> Sent via Deja.com http://www.deja.com/
> Before you buy.

"Resource" includes unlimited quota on all tablespaces.

After granting resource, 

"revoke unlimited quota from <user>"

The grant quotas explicitly on the tables the user should have access
to.

Dave
-- 
These are my opinions, mine I tell you!