Information schema for users

You can use the information_schema.users view to return information about users. You can use a SELECT query to return information about each user, as shown in the example below.

SELECT
  *
FROM
  information_schema.users;

For more information, see Managing users.

Columns in information_schema.users

Each row has the following columns with information about each user.