Alexey Gaidukov wrote : > >I known the name of a role. Is it possible to get all user with the >role's name? > >-- >MaxDB Discussion Mailing List >For list archives: http://lists.mysql.com/maxdb >To unsubscribe: >http://lists.mysql.com/maxdb?>[EMAIL PROTECTED] > > You may ask DOMAIN.ROLEPRIVILEGES :
SELECT GRANTEE FROM DOMAIN.ROLEPRIVILEGES WHERE ROLE = 'MYROLE' (assuming you are looking for a role named MYROLE) Best Regards, Thomas -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
