SoftTree Technologies Technical Support Forums Register • Search • FAQ • Memberlist • Usergroups • Log in MySQL Permissions      SoftTree Technologies Forum Index » SQL Assistant View previous topic View next topic MySQL Permissions Author Message gemisigo Joined: 11 Mar 2010 Posts: 2165 MySQL Permissions What permissions are required for SA in MySQL to operate properly (eg. show objects in Database Explorer, pop-ups, syntax completion, ect.)? Wed Sep 07, 2016 4:13 am SysOp Site Admin Joined: 26 Nov 2006 Posts: 7948 You will need read access to views in INFORMATION_SCHEMA schema, plus read access to the following 3 tables mysql.proc mysql.func mysql.user The last one is the most important because it's used in a query retrieving list of schemas and roles. If you cannot read from mysql.user table, modify "Schemas (MySQL)" query in the options and comment out the UNION ALL part. Wed Sep 07, 2016 11:34 am Display posts from previous:  All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year  Oldest FirstNewest First     SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours Page 1 of 1   Jump to:  Select a forum ----------------SQL AssistantDB Audit, DB Mail, DB Tools24x7 Scheduler, Event Server, Automation SuiteTips & Snippets Repository You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum     Powered by phpBB © 2001, 2005 phpBB Group Design by Freestyle XL / Flowers Online.