CODEWITHSUNDEEP
sqldatabaseoracle-databasetablespace
user3503370
user3503370

Reputation: 31

How to prevent a user from using space in a tablespace?

I tried the following commands,but i can still insert into the table on appts. Why?

MICHAEL@orcl@SQL> alter user michael quota 0M on appts;

User altered.

MICHAEL@orcl@SQL> select tablespace_name,max_bytes from user_ts_quotas;

TABLESPACE_NAME               ,       MAX_BYTES
------------------------------,----------------
APPTS                         ,               0


MICHAEL@orcl@SQL> select tablespace_name,table_name from user_tables;

TABLESPACE_NAME               ,TABLE_NAME
------------------------------,------------------------------
APPTS                         ,TEST_D
....


MICHAEL@orcl@SQL> insert into test_d values(292,'Test',500,2100);

1 row created.

Upvotes: 3

Views: 136

Answers (1)

Kris Wenzel
Kris Wenzel

Reputation: 23

What about using ALTER TABLESPACE to make it read only? You could enter:

ALTER TABLESPACE APPTS READ ONLY

Upvotes: 1

Related Questions