Check for user authentication for current user : User Table « User Permission « SQL / MySQL






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

Check for user authentication for current user

      

SELECT   *
FROM     USER_AUTHS
WHERE    GRANTEE = CURRENT_USER;








Related examples in the same category

1.Query user table
2.Deal with users who can log in from anywhere
3.Check the user_auths table
4.Check the just created user by querying the user table
5.Verify that the user table contains the proper host and user rows.
6.How an account would be added to the user table
7.Query the user table