Re: Stopping user access to system tablespace

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!