Not the answer you need?
Register and ask your own question!

READ Only user

lflacayolflacayo EntrantInactive User Role Beginner
Hello, Im testing the creation of a read only user. I have created the user 'r-db01' with select permissions only. In previous version of Mysql 5.5 if I connected as the ready only user, and I did "show databases;" it would only allow me to see the granted database and information_schema.

I am testing this read only user on the new 5.7 install and when I do a "show databases" as the read only user I created, I see all the databases. Did something change? Is there a new way of achieving this with 5.7?

thank you in advance.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.