Read-Only Tables in 11g

We can now make a table read only in database (11g new feature).
ALTER TABLE ABC READ ONLY;
If someone try any DML on ABC table he will get this error

ORA-12081: update operation not allowed on table SCHEMA.ABC.

To check if the table is read only ,
select read_only from user_tables where table_name='ABC';
ALTER TABLE ABC READ WRITE;  --> this will change the readonly mode of table and DML can be performed on this now.
 
No need to worry about who has select,insert,update,delete on table, If you want to make sure that data is read only, You can make the table readonly.
 
Enjoy...I am sure this is a great feature...and will help DBA/developers a lot to protect the data (Like refrence data)

1 comment:

  1. Are you looking to make money from your websites/blogs using popup ads?
    In case you are, did you take a look at Ero-Advertising?

    ReplyDelete