1.创建用户并将某个数据库的属主修改为该用户
create user uhxl;
alter user uhxl with password ‘uhxl‘;
alter user uhxl with CONNECTION LIMIT 20;
alter database hxl owner to uhxl; ##修改数据库属主
GRANT ALL PRIVILEGES ON DATABASE hxl TO uhxl; ##或是授权
原文:https://www.cnblogs.com/hxlasky/p/12188498.html