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.