content_image/846740.jpg content_image/846741.jpg
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. 

## Example 

## Notes 

mysql> ALTER SCHEMA mydb READ ONLY = 1; mysql> SELECT * FROM INFORMATION_SCHEMA.SCHEMATA_EXTENSIONS WHERE SCHEMA_NAME = ’mydb’; 

<img src='content_image/846740.jpg'>

mysql> ALTER SCHEMA mydb READ ONLY = 0; mysql> SELECT * FROM INFORMATION_SCHEMA.SCHEMATA_EXTENSIONS WHERE SCHEMA_NAME = ’mydb’; 

<img src='content_image/846741.jpg'>

• SCHEMATA_EXTENSIONS  is a nonstandard INFORMATION_SCHEMA  table. 

## 26.3.33 The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table 

The SCHEMA_PRIVILEGES  table provides information about schema (database) privileges. It takes its values from the mysql.db  system table. 

The SCHEMA_PRIVILEGES  table has these columns: 

• GRANTEE 

The name of the account to which the privilege is granted, in ’ user_name ’@’ host_name ’  format. 

• TABLE_CATALOG 

The name of the catalog to which the schema belongs. This value is always def . 

• TABLE_SCHEMA 

The name of the schema. 

• PRIVILEGE_TYPE 

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. 

• IS_GRANTABLE 

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’ . 

## Notes 

• SCHEMA_PRIVILEGES  is a nonstandard INFORMATION_SCHEMA  table. 

