Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

schema lock permission denied Expand / Collapse
Posted Wednesday, April 17, 2013 6:52 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, May 19, 2016 8:03 AM
Points: 42, Visits: 247
Hi. This is a bit of an old thread, but this error happened to me today. And I confirmed that it is caused by missing the select permission on the second side of the linked-server. If you map every login used on the linked-server this can be avoided, but if you use Windows Authentication or "map the corresponding login" you may end up passing a login without the correct permissions and not notice it. Just give the permission and the error will go away.

It is not the most user-friendly message, but as it seems the linked-server feature needs to schema_lock every object on select...

I made a post about this issue:
Post #1443567
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse