I get the following error when trying to execute sp_help as a user who's only access is to the db_datareader role of a user database.
Msg 229, Level 14, State 5, Procedure sp_help, Line 1
The EXECUTE permission was denied on the object 'sp_help', database 'mssqlsystemresource', schema 'sys'.
Attempting the same thing on a similar SQL Server using same security level is successful.
Both are build 9.00.3152.00.
Any ideas?