Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
muralidaran_r
Starting Member
13 Posts |
 Posted - 2008-10-23 : 03:12:47
|
| I get below error for a user 'A' on database 'X'. for other user 'B' every thing working fine.How to compare two users/logins and find the difference? or solve this error?TITLE: Microsoft SQL Server Management Studio------------------------------Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476------------------------------ADDITIONAL INFORMATION:An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)------------------------------SELECT permission denied on object 'extended_properties', database 'mssqlsystemresource', schema 'sys'. (Microsoft SQL Server, Error: 229)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=229&LinkId=20476------------------------------BUTTONS:OK------------------------------ |
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2008-10-23 : 08:48:10
|
| Check which user groups the user getting the error is not in compared to user not getting error. Check which groups have and don't have SELECT permission to the object in question. It will probably mean just adding the user to the other user group. If your not uing groups - manually give the user SELECT permission to the object. |
 |
|
|
|
|
|
Microsoft SQL Server Management Studio Error 229