New in Oracle 11g: Read Only Tables

0 0

In Oracle 11g database it is possible to make a table really read only, also for the owner of that table. Until now a table could only be made read only to other users, by granting only the select privilege to these users. But the owner of the table was always able to do updates and inserts. With the new statement: alter table <table name> read only the table is really read only. And you can reverse it again with: alter table <table name> read write. A small example: 

SQL> alter table emp read only;

Table altered.

SQL> update emp
2  set comm = comm * 1.1;
update emp
*ERROR at line 1:ORA-12081: update operation not allowed on table "JURGEN"."EMP"

SQL> alter table emp read write;

Table altered.

SQL> update emp
2  set comm = comm * 1.1;

14 rows updated.

SQL>

About Post Author

Jurgen Kemmelings

Oracle consultant at AMIS

Jurgen.Kemmelings@amis.nl

Happy

0 0 %

Sad

0 0 %

Excited

0 0 %

Sleepy

0 0 %

Angry

0 0 %

Surprise

0 0 %

Related posts:

Oracle Quiz on SQL and PL/SQL – See Water Burning – paper for ODTUG 2005 Death of the End Date – How LAG and LEAD help fight redundancy Used port numbers by the Oracle OEM agent Mr. Thomas Kyte goes Dutch – Guru4Pro What You Always Wanted to Know (but never dared to ask about…)