Ruxmcs
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
->
http://www.sqlservercentral.com/Forums/Topic267377-146-2.aspx
philippe.haegel
Posted Friday, February 06, 2009 3:16 AM
Grasshopper
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:
http://weblogs.sqlteam.com/mladenp/archive/2007/03/12/60132.aspx
没有评论:
发表评论
‹
›
主页
查看网络版本
没有评论:
发表评论