Hologres创建用户后怎么给用户设置密码

添加的对应的RAM用户，账号密码就是该用户的AK。详情可以参考这篇文档：连接HoloWeb

# 创建用户
CREATE USER "BASIC$aaa" WITH PASSWORD 'aaa';
# 添加到某个db用户组
CALL spm_grant('spm_1_developer', 'BASIC$aaa');

# 修改密码
ALTER USER "BASIC$ccc" WITH PASSWORD 'ccc'

# 同一db下，只能添加到一个用户组
CALL spm_grant('spm_1_admin', 'BASIC$aaa');
"""

CALL spm_grant('spm_1_developer', 'BASIC$aaa'); # 加不了
CALL spm_grant('spm_1_writer', 'BASIC$aaa');      # 加不了
CALL spm_grant('spm_1_viewer', 'BASIC$aaa');     # 加不了
"""
CALL spm_grant('spm1_admin', 'BASIC$tset');
CALL spm_revoke('spm1_admin', 'BASIC$tset' );
CALL spm_grant('spm1_developer', 'BASIC$tset');
CALL spm_revoke('spm1_developer', 'BASIC$tset' );
CALL spm_grant('spm1_writer', 'BASIC$tset');
CALL spm_revoke('spm1_writer', 'BASIC$tset' );
CALL spm_grant('spm1_viewer', 'BASIC$tset');
CALL spm_revoke('spm1_viewer', 'BASIC$tset' );

# superuser需要切换到spm_2数据库中，执行下面sql语句(为用户添加其他db权限)
CALL spm_revoke('spm_2_developer', 'BASIC$aaa');