Ads

30 November 2012

The SELECT permission was denied on the object 'extended_properties', database 'mssqlsystemresource', schema 'sys'. (Microsoft SQL Server, Error: 229)

Step1 :- Go to the properties account
Step2:- Choose User Mapping
Step 3:- Choose Respective DB
Step 4:- Remove db_denydatareader (uncheck)
Step 5:- Click Ok and Refresh


Another Issue :- http://blog.sqlauthority.com/2012/06/19/sql-server-solution-user-not-able-to-see-any-user-created-object-in-tables-security-and-permissions-issue/



at

4 comments:

  1. AnonymousOctober 18, 2013 at 6:08 PM

    Thanks for this. This is such a simple explanation with how to fix.

    Too many other posts offer speculation and to many "possible fixes

    ReplyDelete
  2. UnknownJanuary 23, 2016 at 7:22 AM

    you are awesome!

    ReplyDelete
  3. AnonymousJune 30, 2016 at 11:45 PM

    Thanks, you are the best!!

    ReplyDelete
  4. ddmcneillOctober 20, 2016 at 2:52 AM

    I tried this and it did not work.

    ReplyDelete

Subscribe to: Post Comments (Atom)