I have a production MySQL database hosted on AWS for an eCommerce store I work with. Employees in the firm are requesting access to our live SQL database to use with BI tools like Tableau/Qlikview. How can I grant these users read-only permissions to analyze data from the live database and not the ability to write data?
Mysql – Give third-party access to AWS hosted MySQL
amazon-rdsawsMySQL
Best Answer
It's explained in detail here (sample code below).
Don't forget though that people with
SELECT
privileges can cripple a database as surely as if they hadDELETE
privileges by running complex reports.Code from website: