May 27, 2013 at 4:10 am
Hi All,
We have a Database and a user with Db_owner privileges.
Everything was fine till yesterday. from Yesterday that user is not able access any of the tables from GUI also through query.
only Sysadmin are able to access the tables. What might be the issue and how to resolve this ?
Please help me in this. Below is the error, I am getting:
TITLE: Microsoft SQL Server Management Studio
------------------------------
Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)
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)
------------------------------
The SELECT permission was denied on the 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=10.00.1600&EvtSrc=MSSQLServer&EvtID=229&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
TITLE: Microsoft SQL Server Management Studio
------------------------------
Cannot show requested dialog.
------------------------------
ADDITIONAL INFORMATION:
Cannot show requested dialog. (SqlMgmt)
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
The SELECT permission was denied on the object 'system_objects', database 'mssqlsystemresource', schema 'sys'.
The SELECT permission was denied on the object 'fulltext_catalogs', database 'mssqlsystemresource', schema 'sys'. (Microsoft SQL Server, Error: 229)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.1600&EvtSrc=MSSQLServer&EvtID=229&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
Thank You.
Regards,
Raghavender Chavva
May 27, 2013 at 4:16 am
User has only db_owner and public roles on the database. No other roles selected.
We have tested by creating new user and provided the db_owner role. Still same problem.
Thank You.
Regards,
Raghavender Chavva
May 27, 2013 at 4:18 am
The error message "The SELECT permission was denied on the object 'extended_properties', database 'mssqlsystemresource', schema 'sys'." implies that DENY or REVOKE access is applied on the [mssqlsystemresource] database. Or perhaps someone dropped the [mssqlsystemresource] database?
May 27, 2013 at 4:31 am
Issue resolved.
The user is windows login.
Some one has given db_deny permissions for Built in/administrator. After revoking these permissions issue resolved.
Thank You.
Regards,
Raghavender Chavva
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply