openGauss每日一练第4天|openGauss创建角色、修改角色属性、更改角色权限和删除角色

课后作业

1.创建角色role1为系统管理员, role2指定生效日期, role3具有LOGIN属性

\du
CREATE ROLE role1 sysadmin identified by 'open_123';

CREATE ROLE role2 WITH LOGIN PASSWORD 'open_456' VALID BEGIN '2021-12-10' VALID UNTIL '2021-12-30';

CREATE ROLE role3 WITH LOGIN PASSWORD 'open_789';

\du+

2.重命名role1

alter role role1 rename to role100;

3.修改role2密码

alter role role2 identified by 'open_520' replace 'open_456';

4.将omm权限授权给role3,再回收role3的权限

\du+ role3

GRANT omm to role3 with admin option;
\du+ role3
revoke all privilege from role3;
\du+ role3

5.删除所有创建角色过程中使用\du或\du+查看角色信息

drop role role100;
drop role role2;
drop role role3;
\du