Alter Database

Important

This documentation has been retired and might not be updated. The product, service, or technology mentioned in this content is no longer supported. See ALTER DATABASE.

ALTER [DATABASE|SCHEMA] db_name SET DBPROPERTIES (key=val, ...)

SET DBPROPERTIES

Specify a property named key for the database and establish the value for the property respectively as val. If key already exists, the old value is overwritten with val.

Assign owner

ALTER DATABASE db_name OWNER TO `user_name@user_domain.com`

Assign an owner to the database.