Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

schema lock permission denied Expand / Collapse
Author
Message
Posted Wednesday, April 17, 2013 6:52 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, July 25, 2014 11:25 AM
Points: 22, Visits: 159
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: http://thelonelydba.wordpress.com/2013/04/17/sql-and-linked-servers-the-schema-lock-permission-was-denied-on-the-object/
Post #1443567
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse