opengauss每日一练第4天-课后作业

课后作业
1.创建角色role1为系统管理员, role2指定生效日期, role3具有LOGIN属性
create role role1 SYSADMIN identified by 'role1_pass';
create role role2 PASSWORD 'role2_pass' VALID BEGIN '2021-12-06' ;
create role role3 LOGIN identified by 'role3_pass';
\du
\du+

2.重命名role1
ALTER ROLE role1 RENAME TO role11;
\du

3.修改role2密码
ALTER ROLE role2 IDENTIFIED BY 'abcd@123' replace 'role2_pass';

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

5.删除所有创建角色
drop role role11;
drop role role2;
drop role role3;

过程中使用\du或\du+查看角色信息