ALTER VIEW Statement Enabling encryption for a general tablespace fails if any table in the tablespace belongs to a schema defined with  DEFAULT ENCRYPTION=’N’ . Similarly, disabling encryption fails if any table in the general tablespace belongs to a schema defined with  DEFAULT ENCRYPTION=’Y’ . The  DEFAULT ENCRYPTION schema option was introduced in MySQL 8.0.16. If an  ALTER TABLESPACE  statement executed on a general tablespace does not include an ENCRYPTION  clause, the tablespace retains its current encryption status, regardless of the default_table_encryption  setting. When a general tablespace or the  mysql  system tablespace is encrypted, all tables residing in the tablespace are encrypted. Likewise, a table created in an encrypted tablespace is encrypted. The  INPLACE  algorithm is used when altering the  ENCRYPTION  attribute of a general tablespace or the mysql  system tablespace. The  INPLACE  algorithm permits concurrent DML on tables that reside in the tablespace. Concurrent DDL is blocked. For more information, see Section 15.13, “InnoDB Data-at-Rest Encryption” . The  ENGINE_ATTRIBUTE  option (available as of MySQL 8.0.21) is used to specify tablespace attributes for primary storage engines. The option is reserved for future use. Permitted values are a string literal containing a valid  JSON  document or an empty string (’’). Invalid  JSON is rejected. ALTER TABLESPACE ts1 ENGINE_ATTRIBUTE=’{" key ":" value "}’; ENGINE_ATTRIBUTE  values can be repeated without error. In this case, the last specified value is used. ENGINE_ATTRIBUTE  values are not checked by the server, nor are they cleared when the table’s storage engine is changed. It is not permitted to alter an individual element of a JSON attribute value. You can only add or replace an attribute. This statement changes the definition of a view, which must exist. The syntax is similar to that for  CREATE VIEW  see Section 13.1.23, “CREATE VIEW Statement” ). This statement requires the  CREATE VIEW  and DROP  privileges for the view, and some privilege for each column referred to in the  SELECT  statement. ALTER VIEW  is permitted only to the definer or users with the  SET_USER_ID  privilege (or the deprecated SUPER  privilege). 13.1.11 ALTER VIEW Statement ALTER [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}] [DEFINER =  user ] [SQL SECURITY { DEFINER | INVOKER }] VIEW  view_name  [( column_list )] AS  select_statement [WITH [CASCADED | LOCAL] CHECK OPTION] CREATE {DATABASE | SCHEMA} [IF NOT EXISTS]  db_name [ create_option ] ... create_option : [DEFAULT] { CHARACTER SET [=]  charset_name | COLLATE [=]  collation_name | ENCRYPTION [=] {’Y’ | ’N’} } 13.1.12 CREATE DATABASE Statement 2507