Saturday 15 August 2015

database permissions - How to stop mySQL users calling "show" functions -


How can we "query the database" the query; Or "Show Table;" In mysql for any non-root user it's possible. If so, please provide an example or a suitable link ... it shows ..

Thanks in advance ........

< Div class = "post-text" itemprop = "text">

The non-root user only looks at all the databases if they have global rights (such as GRANT some ON * . *) Therefore the solution is always giving everything on database names , never global.


No comments:

Post a Comment