Please check that you didn't check the following DB role:
1. db_denydatareader
2. db_denydatawriter
Please uncheck both of them, this will solve your problem.
Steps to uncheck the roles:
1. db_denydatareader
2. db_denydatawriter
Please uncheck both of them, this will solve your problem.
Steps to uncheck the roles:
- Open SQL Management Studio
- Expand your database
- Expand the "Security" Folder
- Expand "Users"
- Right click the user (the one that's trying to perform the query)
- Make sure you uncheck
No comments:
Post a Comment