ALTER DATABASE Statement

The ALTER DATABASE statement changes the characteristics of a database.

Use the SET OWNER clause to transfer the ownership of the database from the current owner to another user or a role.

The database owner is originally set to the user who creates the database. The term OWNER is used to differentiate between the ALL privilege that is explicitly granted via the GRANT statement and a privilege that is implicitly granted by the CREATE DATABASE statement.

Syntax:

  2. ALTER DATABASE database_name SET OWNER USER user_name;

Statement type: DDL

Cancellation: Cannot be cancelled.

Added in: Impala 3.1

Parent topic: Impala SQL Statements