Showing posts with label Sql Server Error 229. Show all posts
Showing posts with label Sql Server Error 229. Show all posts

Friday, July 5, 2019

Sql-Server the Select permission was denied on the object 'types', Error 229

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. Open SQL Management Studio
  2. Expand your database
  3. Expand the "Security" Folder
  4. Expand "Users"
  5. Right click the user (the one that's trying to perform the query)
  6. Make sure you uncheck