Mega Code Archive

 

Categories / MySQL / User Permission

 

Check the user_auths table

SELECT   GRANTEE FROM     USER_AUTHS WHERE    PRIVILEGE = 'SELECT' UNION SELECT   GRANTEE FROM     DATABASE_AUTHS WHERE    DATABASE_NAME = 'TENNIS' AND      PRIVILEGE = 'SELECT' UNION SELECT   GRANTEE FROM     TABLE_AUTHS WHERE    TABLE_CREATOR = 'TENNIS' AND      PRIVILEGE = 'SELECT' AND      TABLE_NAME = 'PLAYERS'