Protecting Mater tables in Oracle 11g+

Dear Users,

Please use the below option to protect the master tables to avoid un-wanted updates/delete/inserts. Allow only to the users who is having the rights just before the update/delete/insert and change back to read-only once the operations completed. This will be very useful in apex environment project.

ALTER TABLE table_name READ ONLY;
ALTER TABLE table_name READ WRITE;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s