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 

Comments

Popular posts from this blog

PHPMotion implementation - URL based videos (Hosted on separate location) -

javascript - Using Windows Media Player as video fallback for video tag -

c# - Unity IoC Lifetime per HttpRequest for UserStore -