Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Stopping user access to system tablespace
Could it be possible that the user has been granted the resource option which I believe would give that user access to all tablespaces. Creating the default tablespace of users doesn't stop a user from creating objects else where it just points them in the right direction if they don't have a clue about create table <..> tablespace <.....> ; Revoke resource from that user and explicitly grant the user the needed grants.
Ken
Gordy <gdsell_at_my-deja.com> wrote in message
news:8k34i6$m5o$1_at_nnrp1.deja.com...
>
>
> 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.
Received on Thu Jul 06 2000 - 00:00:00 CDT