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: Wednesday, June 22, 2016 5:29 AM
Points: 44, Visits: 254
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