tag:blogger.com,1999:blog-16959946.post4941110852894236525..comments2023-12-09T16:44:47.897+01:00Comments on The Data Charmer: MySQL 8.0 rolesGiuseppe Maxiahttp://www.blogger.com/profile/15801583338057324813noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-16959946.post-82317364243545509842017-03-28T14:08:50.827+02:002017-03-28T14:08:50.827+02:00Statements like "SHOW GRANTS FOR user1 USING ...Statements like "SHOW GRANTS FOR user1 USING role1" will show privileges granted to user1 through role1. If multiple roles are granted to an user, currently there is no way to see consolidated list of privileges that an user can enjoy. We have to fist see all the granted roles for an user, and then execute another statement like : "SHOW GRANTS FOR user1 USING role1, role2, ....". At times admin may need this type of information. Something like following can be implemented : "SHOW GRANTS FOR user1 USING ALL", which will show all privileges an user have.Prabeenhttps://www.blogger.com/profile/02766935146725399418noreply@blogger.comtag:blogger.com,1999:blog-16959946.post-6292123048099033692017-03-27T11:12:42.636+02:002017-03-27T11:12:42.636+02:00Nice to have a similar concept like PostgreSQL.Nice to have a similar concept like PostgreSQL.Holger Thielnoreply@blogger.com