New in Oracle 11g: Read Only Tables

0 0
Read Time:46 Second

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
Happy
Happy
0 %
Sad
Sad
0 %
Excited
Excited
0 %
Sleepy
Sleepy
0 %
Angry
Angry
0 %
Surprise
Surprise
0 %

Average Rating

5 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%

3 thoughts on “New in Oracle 11g: Read Only Tables

Comments are closed.

Next Post

Maven JMeter plugin and report generation (the last steps to get it working)

JMeter (http://jakarta.apache.org/jmeter/)is a powerful tool for functional and performance testing web applications. JMeter, opposed to selenium, also works perfectly on generated applications (like Oracle ADF ). One of the key strengths of JMeter is the automation. The same test can be repeated after each (minor) release. This is a great […]
%d bloggers like this: