Senthil Murugan's Blog

Home » Oracle » Protecting Mater tables in Oracle 11g+

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;
Advertisements

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: