Re: Stopping user access to system tablespace

hi,

the resource role includes 'unlimited quota'

to fix that ..

create user *** identified by **** default tablespace users temporary tablespace temp;

grant connect, resource to ***

revoke unlimited tablespace from ****

alter user **** quota system 0m;
alter user **** quota users 10m;

regards
alex venzke

Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free!
http://www.keen.com Received on Thu Jul 06 2000 - 00:00:00 CDT