MySQL Forums
Forum List  »  Security

Re: Newly created users not seeing tables they've been granted privs on in clients
Posted by: Georgi Kodinov
Date: October 12, 2017 02:51AM

I fully agree with Peter here. Let's please have the proper script in.
The idea of the mysql SHOW/I_S commands is that they'd show you only the database objects you have access to.
I'd check the effective user to make sure it's the one I expect it to be, then I would check the SHOW GRANTS output and compare it to the SHOW DATABASES/SHOW TABLES/etc output. And to the actual list of database objects as returned to a user with all privileges.
If they don't add up according to the principle above I'd file a bug.

Georgi "Joro" Kodinov
MySQL SrvGen team lead
Plovdiv, Bulgaria

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Newly created users not seeing tables they've been granted privs on in clients
369
October 12, 2017 02:51AM


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.