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.
https://blog.sqlauthority.com/2009/06/27/sql-server-fix-error-17892-logon-failed-for-login-due-to-trigger-execution-changed-database-context...
No comments:
Post a Comment