Friday, March 23, 2012

Read only

How can I make a table(not the entire database)read only?GRANT SELECT ON myTable TO <User/Role>

DENY INSERT, UPDATE, DELETE ON myTable TO <User/Role>

Look these up in BOLsql

No comments:

Post a Comment