openGauss每日一练第4天 | 学习openGauss角色增删改

1.创建角色role1为系统管理员, role2指定生效日期, role3具有LOGIN属性
\du
CREATE ROLE role1 sysadmin identified by 'zhang_123';
CREATE ROLE role2 WITH LOGIN PASSWORD 'zhang_456' VALID BEGIN '2021-12-10' VALID UNTIL '2021-12-30';
CREATE ROLE role3 WITH LOGIN PASSWORD 'zhang_789';
\du+

(这块应该是一个bug，反复执行多次每次的显示结果都不一样)

2.重命名role1
\du+
alter role role1 rename to role100;
\du+

3.修改role2密码
alter role role2 identified by 'zhang_891' replace 'zhang_456';

4.将omm权限授权给role3,再回收role3的权限
\du+ role3
GRANT omm to role3 with admin option;
\du+ role3
revoke all privilege from role3;
\du+ role3

5.删除所有创建角色
drop role role100;
drop role role2;
drop role role3;
\du