Check the user_auths table : User Table « User Permission « SQL / MySQL

1. SQL / MySQL
2. User Permission
3. User Table

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'

   
    
    
    
    
    
  

Related examples in the same category