I have a problem here. I have an USER suppose "A". I want to restrict that user from creating any objects in SYSTEM tablespace.
How do I do this. I have tried
alter user A quota 0 on SYSTEM;
alter system set resource_limit = true;
But still that user is able to create tables in SYSTEM tablespace and populate rows. Please help me out.....
Perhaps the user's default tablespace and temporary tablespace are set to SYSTEM.
1. Log in as DBA
2. Determine the default and temporary tablespaces for
the user from the DBA_USERS view
3. If set to SYSTEM,
ALTER USER joe default tablespace USERS;
ALTER USER joe temporary tablespace TEMP;
OCP DBA 8i, 9i, 10g
Check your user's system privileges: I'm sure your user has been granted UNLIMITED TABLESPACE privilege, that is why setting his quota on SYSTEM to 0 has had no effect.
Isue "REVOKE UNLIMITED TABLESPACE FROM A;" and check if he is still able to create objects in SYSTEM tablespace.
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Click Here to Expand Forum to Full Width