Microsoft Sql Server 2008 Error 229
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site
Microsoft Sql Server Error 229 Mssqlsystemresource
About Us Learn more about Stack Overflow the company Business Learn more about error 229 in sql server 2012 hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss
Sql Server Error 229 Select Permission Denied
Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Permissions issue in SSMS: sqlserver error: 229, the execute permission was denied on the object 'sp_sqlagent_update_agent_xps' “The SELECT permission was denied on the object 'extended_properties', database 'mssqlsystem_resource', … Error 229)” up vote 7 down vote favorite 1 Here’s the simplest repro case possible. Create a brand new database. (I'm using SQL 2005.) Create a login, a SQL user, and a table in the new database (see sample code below). Launch SSMS and open Object Explorer, logging in as the newly-created user. view server state permission was denied on object 'server' database 'master' error 300 Attempt to open the "Tables" folder in the Object Explorer. The Problem Fails with this error message. Message Text: TITLE: Microsoft SQL Server Management Studio Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc) For help, click: link 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: link This user can access the table and the record in the table. But the user cannot access the list of tables in Object Explorer. SELECT USER_NAME() AS CurrentUser, col1 FROM dbo.TestTable CurrentUser col1 ----------- ---- robg_test 1000 The only work-around I have found is to give the user higher-than-necessary privileges (like db_datareader). The Question: What is the minimum privilege required to allow this user to open the table list in Object Explorer? I have tried granting the user various privileges on the dbo schema, but that did not help. Note also that I am using a SQL user simply to illustrate the problem. The original problem was with an AD user. Here is a relatively similar question at serverfault. Code SE
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: The SELECT permission was denied on the object 'extended_properties', database
Execute Permission Was Denied On The Object 'xp_sqlagent_enum_jobs' Database 'mssqlsystemresource'
'mssqlsystemresource', schema 'sys'. (Microsoft SQL Server, Error: 229) SQL Server > SQL error 229 sql server 2008 r2 Server Express Question 0 Sign in to vote I have created a user and given him the owner
Microsoft Sql Server Error 300
rights for the database. Though I can LogIn as the user, I cannot access the databases. I am having the error mesage: Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc) For http://stackoverflow.com/questions/2002773/permissions-issue-in-ssms-the-select-permission-was-denied-on-the-object-exte 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.50.1600&EvtSrc=MSSQLServer&EvtID=229&LinkId=20476 Sha_woop Monday, June 13, 2011 10:11 AM Reply | Quote Answers 2 Sign in to vote Hi Sha, It looks like https://social.msdn.microsoft.com/Forums/sqlserver/en-US/d04388c2-63a7-4acb-b704-0b55f861118b/the-select-permission-was-denied-on-the-object-extendedproperties-database?forum=sqlexpress the user has not the necessary permission on the database. And you could check if the he is assigned to the proper Server Role , User Mappings and the schemas he has permissions to. Finally go to 'permissions' in the 'properties' of the database to configure the user permission. If you want to read up on fixed database roles and which data object they give access to, please follow this link (http://msdn.microsoft.com/en-us/library/ms189121%28v=SQL.90%29.aspx). Or you could try to run this query to grant higher permission to the user. Use master go GRANT VIEW ANY DEFINITION TO user_login; Go Hope this helps.Best Regards, Peja Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Marked as answer by Peja Tao Monday, June 20, 2011 8:58 AM Unmarked as answer by Peja Tao Tuesday, June 21, 2011 7:46 AM Marked as answer by Sha_woop Thursday, June 23, 2011 6:15 AM Wednesday, June 15, 2
Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers http://serverfault.com/questions/43606/what-permissions-might-be-missing-on-error-229-from-tables-node-on-ssms-object or posting ads with us Server Fault Questions Tags Users Badges Unanswered Ask Question _ Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute: Sign up Here's how it works: http://www.sql-server-performance.com/forum/threads/microsoft-sql-server-management-studio-error-229.28557/ Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top What permissions might be missing on error 229 from 'tables' node on SSMS object explorer up vote 1 down vote favorite sql server I have just added a login to test an ETL process on a database and I get the error described below when connect using the account I click on the 'Tables' tab on the object explorer on SSMS on a database with the login set up as a user. Failed to retrieve data for this request (Microsoft.SqlServer.SmoEnum) Additional Information An exception occured while executing a Transact-SQL statement or batch (Microsoft.SqlServer.ConnectionInfo) The SELECT permissions was denied on the object 'extended_properties' database 'mssqlsystemresource', microsoft sql server schema 'sys'. (Microsoft SQL Server, Error: 229). This looks like it should be a noddy mistake but I can't find anything that fixes the problem in a quick google search. Any ideas? sql-server sql-server-2005 permissions user-management share|improve this question edited Aug 24 '09 at 10:59 Alex Angas 1,53312234 asked Jul 21 '09 at 16:16 ConcernedOfTunbridgeWells 8,36012248 Do you get this error when you log in as SA (or equivalant administrator rights)? –Mark Henderson♦ Jul 21 '09 at 21:26 No. Only when I log in as the user I just created. –ConcernedOfTunbridgeWells Jul 22 '09 at 8:51 I posted a somewhat similar question on stackoverflow here: stackoverflow.com/questions/2002773/… –Rob Garrison Jan 4 '10 at 23:13 add a comment| 1 Answer 1 active oldest votes up vote 1 down vote accepted Might not be the same thing but I was getting that error today. Turned out that in my haste to grant a user full access to a database I ticked all the boxes under role members including db_denydatareader, db_denydatawriter. share|improve this answer answered Mar 10 '11 at 10:35 Adam Butler 31927 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agree to the privacy policy and terms of service. Not
Server Management Studio Error 229 Discussion in 'SQL Server 2005 General DBA Questions' started by muralidaran_r, Oct 23, 2008. muralidaran_r New Member --------------------------------------------------------------------------------I get below error for a user 'A' on database 'X' while clicking on tables and stored procedures in object explorer. 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?ProdN...r&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?ProdN...9&LinkId=20476 muralidaran_r, Oct 23, 2008 #2 HanShi New Member Looks like user 'A' doesn't have the necessary rights on the database. Check if both users are assigned to the same ServerRole and have the same UserMappings. Also check the schemas each user has permissions to. Finally goto 'permissions' in the 'properties' of the database and compare the permissions from user 'A' with user 'B'. Or script out the logins and assigned rights/permissions on the database and compare the script of both users. HanShi, Oct 23, 2008 #3 (You must log in or sign up to reply here.) Share This Page Tweet Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums. Your name or email address: Do you already have an account? F