sql - How to prevent a user from using space in a tablespace? -
i tried following commands,but can still insert table on appts. why? michael@orcl@sql> alter user michael quota 0m on appts; user altered. michael@orcl@sql> select tablespace_name,max_bytes user_ts_quotas; tablespace_name , max_bytes ------------------------------,---------------- appts , 0 michael@orcl@sql> select tablespace_name,table_name user_tables; tablespace_name ,table_name ------------------------------,------------------------------ appts ,test_d .... michael@orcl@sql> insert test_d values(292,'test',500,2100); 1 row created. what using alter tablespace make read only? enter: alter tablespace appts read