Labels

Friday, 12 February 2016

SQL DBA : How many ways you can make a table as read only

There might be many cases where table needs to be as Read-Only in order to maintain the existing data.

I have mentioned below few possibilities which ever I knows

1. Put the table on Read-Only filegroup.

2. Deny Permission.

3. Make the database Read-Only.

4. With help of triggers.

No comments:

Post a Comment