The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table The options for the schema. If the schema is read only, the value contains  READ ONLY=1 . If the schema is not read only, no  READ ONLY  option appears. The  SCHEMA_PRIVILEGES  table provides information about schema (database) privileges. It takes its values from the  mysql.db  system table. • GRANTEE • TABLE_CATALOG • TABLE_SCHEMA • PRIVILEGE_TYPE • IS_GRANTABLE • SCHEMA_PRIVILEGES  is a nonstandard  INFORMATION_SCHEMA  table. Notes The name of the account to which the privilege is granted, in  ’ user_name ’@’ host_name ’  format. The name of the catalog to which the schema belongs. This value is always  def . The name of the schema. The privilege granted. The value can be any privilege that can be granted at the schema level; see Section 13.7.1.6, “GRANT Statement” . Each row lists a single privilege, so there is one row per schema privilege held by the grantee. YES  if the user has the  GRANT OPTION  privilege,  NO  otherwise. The output does not list  GRANT OPTION as a separate row with  PRIVILEGE_TYPE=’GRANT OPTION’ . • SCHEMATA_EXTENSIONS  is a nonstandard  INFORMATION_SCHEMA  table. The  SCHEMA_PRIVILEGES  table has these columns: 26.3.33 The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table Notes Example mysql>  ALTER SCHEMA mydb READ ONLY = 1; mysql>  SELECT * FROM INFORMATION_SCHEMA.SCHEMATA_EXTENSIONS WHERE SCHEMA_NAME = ’mydb’; mysql>  ALTER SCHEMA mydb READ ONLY = 0; mysql>  SELECT * FROM INFORMATION_SCHEMA.SCHEMATA_EXTENSIONS WHERE SCHEMA_NAME = ’mydb’; +--------------+-------------+-------------+ | CATALOG_NAME | SCHEMA_NAME | OPTIONS | +--------------+-------------+-------------+ | def | mydb | READ ONLY=1 | +--------------+-------------+-------------+ +--------------+-------------+---------+ | CATALOG_NAME | SCHEMA_NAME | OPTIONS | +--------------+-------------+---------+ | def | mydb | | +--------------+-------------+---------+ 4820