Error 1345
Updates: Status: Not a Bug Impact on me: None Category:MySQL Server: Security: Privileges Severity:S2 (Serious) Version:5.5.19 OS:Linux (Fedora 16, Centos 5.7) Assigned to: Jon Hauglid Triage: Needs Triage: D2 (Serious) View Add Comment Files Developer Edit Submission View Progress Log Contributions [1 Feb 2012 21:21] James Kesser Description: After upgrading to 5.5.20 some of my users that have only global SELECT grants were getting an error message when running an explain on a view: ERROR 1345 (HY000): EXPLAIN/SHOW can not be issued; lacking privileges for underlying table As stated previously, the user has SELECT ON *.* and any other user with these grants gets the error. A user with ALL ON *.* does not get the error. I have verified the error does NOT occur in 5.5.16, but it happens in 5.5.19 and 5.5.20. How to repeat: -- as a user with sufficient privs, create a simple table / view: DROP TABLE IF EXISTS t; CREATE TABLE t (a INT); DROP VIEW IF EXISTS v; CREATE VIEW v AS SELECT * FROM t; -- as a user with SELECT ON *.* mysql> SELECT * FROM t; Empty set (0.00 sec) mysql> EXPLAIN SELECT * FROM t; +----+-------------+-------+------+---------------+------+---------+------+------+-------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+-------+------+---------------+------+---------+------+------+-------+ | 1 | SIMPLE | t | ALL | NULL | NULL | NULL | NULL | 1 | | +----+-------------+-------+------+---------------+------+---------+------+------+-------+ 1 row in set (0.00 sec) mysql> SELECT * FROM v; Empty set (0.00 sec) mysql> EXPLAIN SELECT * FROM v; ERROR 1345 (HY000): EXPLAIN/SHOW can not be issued; lacking privileges for underlying table [1 Feb 2012 23:37] Miguel Solorzano Thank you for the bug report. h:\dbs>h:\dbs\5.5\bin\mysql -uroot --port=3540 --prompt="mysql 5.5 >" Welcome to the MyS
sophisticated digital experiences Web content & Customer Journey Sitefinity CMS Build engaging websites with intuitive web content management Application Development, Testing & Deployment DevCraft Leverage a complete UI toolbox for web, mobile and desktop development OpenEdge Build, protect and deploy apps across any platform and mobile device Kendo UI Build rich, smart HTML5 and JavaScript apps for any platform, browser or device Telerik Platform Build mobile apps for iOS, Android and Windows Phone Nativescript Use Angular, TypeScript or https://bugs.mysql.com/bug.php?id=64198 JavaScript to build truly native mobile apps Rollbase Rapidly develop, manage and deploy business apps, delivered as SaaS in the cloud Test Studio Automate UI, load and performance testing for web, desktop and mobile Modulus Host, deploy and scale Node.js, Java and .NET Core apps on premise or in the cloud Data Connectivity http://knowledgebase.progress.com/articles/Article/000032715 DataDirect Connectors Optimize data integration with high-performance connectivity Business Rules Management Corticon Automate decision processes with a no-code business rules engine View All Products Solutions Digital Business Transformation Transform your businesses in order to survive in a completely digitized and connected world driven by software innovation. Web Scale Globally scale websites with innovative content management and infrastructure approaches Modernization UX and app modernization to powerfully navigate todays digital landscape Omni-Channel Engagement Content-focused web and mobile solution for empowering marketers aPaaS Fuel agility with ever-ready applications, built in the cloud Enterprise Mobility Faster, tailored mobile experiences for any device and data source New & Trending E-book The Digital Ultimatum: Why Businesses Must Digitally Transform to Survive â€" and Thrive Survey Report The State of Digital Business Support & Learning Support Support Services Knowledge Base Customer Order Management Download Center Services Training Consulting Services Managed Database Offering Learning Documentation Webinars How-To Videos Whitepapers Community Blogs Success Stories Partne
1345 - Error Code 0x541Microsoft Windows Error Code 1345:'ERROR_INVALID_GROUP_ATTRIBUTES'Error DescriptionThe specified attributes are invalid or incompatible with the attributes http://www.wmpub.com/error1345_errorcode0x541.php for the group as a whole.
Please note that permanent damage may occur to your PC if Error 1345 - Error Code 0x541 is left alone and not repaired immediately. Error 1345 - Error Code 0x541 Solution To repair this error, download and install each of the software tools listed below. These have been specifically designed to help repair this error; Download Windows Software Update error 1345 - updates the drivers that control your computer. Download Error 1345 - Error Code 0x541 Fix - helps fix Error 1345 - Error Code 0x541 on your system. Sometimes Error 1345 - Error Code 0x541 can be caused by spyware or virus infections, so it's wise to run a removal program like the one below, to remove any spyware infections. Download Spyware Remover - scans error 1345 and removes all spyware, adware or viruses on your system. To begin the installation, once you've clicked on the a link above, a new window should appear with several options on it. Click Open or Run this program from its current location. Or to save the download to your computer for installation at a later time, click Save or Save this program to disk. Once installed, run each program by pressing its scan/update button. Once the checks are done, you can let the tools fix the problem. Free Support From Qualified Engineers Get free support from one of our experts by entering your name, error message code (i.e. Error 1345 - Error Code 0x541) and your email address into the form below and one of our I.T. experts will email you personally within 30 minutes.. Try It For Free - Just Enter Your Error Code Below Supported operating systems: Windows 7, Windows Vista, Windows XP, Windows Me, Windows 2000 & Windows 98. This page shows you how to repair Error 1345 - Error Code 0x541 and related errors. Copyright 2010. All rights reserved. Sitemap | Error 1345 - Error Code 0x541