Friday, November 20, 2015

Grant Read or write access to only 1 table

Follow below steps:
1. Create login, and Add to public to ABC database
2.Grant Select , insert, update , delete on Tablename to Login 
Note: if you add login to db_reader group, the user will have Read access to all Database tables.

No comments:

Post a Comment

https://blog.sqlauthority.com/2009/06/27/sql-server-fix-error-17892-logon-failed-for-login-due-to-trigger-execution-changed-database-context...