MySQL Forums
Forum List  »  MySQL for Excel

Re: Restricting User access to elements of Plugin
Posted by: Javier Treviño
Date: February 22, 2016 04:09PM

Hi Richard,
Thanks for writing in our forums!

Yes this can be done, but bear in mind that it is not restricted within the plugin and this is as per design since Excel does not manage users. Instead this must be done at the Server side, you should create users that have only the least privileges to extract data from the MySQL Server (using the GRANT statement http://dev.mysql.com/doc/refman/5.7/en/grant.html) you should be able to restrict that your users do not update accidentally the data and give them read-only access.

Best regards.

====================================
Javier Treviño
MySQL on Windows Team

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Restricting User access to elements of Plugin
963
February 22, 2016 04:09PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.