2009年6月19日星期五

SQL: SELECT permission denied on object 'sysobjects', database 'mssqlsystemresource', schema 'sy

SELECT permission denied on object 'sysobjects', database 'mssqlsystemresource', schema 'sys'. SELECT permission denied on object 'sysobjects', database 'mssqlsystemresource', schema 'sys'. SELECT permission denied on object 'sysobjects', database 'mssqlsystemresource', schema 'sys'. SELECT permission denied on object 'sysobjects', database 'mssqlsystemresource', schema 'sys'. SELECT permission denied on object 'sysobjects', database 'mssqlsystemresource', schema 'sys'. SELECT permission denied on 
 Posted Friday, February 06, 2009 3:16 AM    
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper 

Group: General Forum Members 
Last Login: Tuesday, March 24, 2009 5:16 AM 
Points: 22, Visits: 12
I had the same problem, because the user had the db_denydatareader property checked.
I unchecked the property and it worked well.

Also:

没有评论: