第4天:角色管理学习作业打卡

学习目标：学习openGauss创建角色、修改角色属性、更改角色权限和删除角色

1.创建角色

role1 为系统管理员, role2 指定生效日期, role3 具有LOGIN属性

omm=# CREATE ROLE role1 SYSADMIN IDENTIFIED BY 'pwd_role1';
NOTICE:  The encrypted password contains MD5 ciphertext, which is not secure.
CREATE ROLE
omm=# CREATE ROLE role2 PASSWORD 'pwd_role2' VALID BEGIN '2021-12-16' VALID UNTIL '2021-12-31'; 
NOTICE:  The encrypted password contains MD5 ciphertext, which is not secure.
CREATE ROLE
omm=# CREATE ROLE role3 LOGIN IDENTIFIED BY 'pwd_role3';
NOTICE:  The encrypted password contains MD5 ciphertext, which is not secure.
CREATE ROLE
CREATE ROLE role4 WITH LOGIN IDENTIFIED BY 'pwd_role4';

2.重命名 role1

ALTER ROLE role1 RENAME TO role10;

omm=# ALTER ROLE role1 RENAME TO role10;
NOTICE:  MD5 password cleared because of role rename
ALTER ROLE

3.修改role2密码

ALTER ROLE role2 IDENTIFIED BY ‘abcd@789’;

omm=# alter role role2 identified by 'abcd@789';
NOTICE:  The encrypted password contains MD5 ciphertext, which is not secure.
ALTER ROLE

4.角色授权

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

omm=# GRANT omm to role3;
GRANT ROLE

omm=# \du+ role3
                  List of roles
 Role name | Attributes | Member of | Description 
-----------+------------+-----------+-------------
 role3     |            | {omm}     | 

omm=#
omm=# revoke all privilege from role3;
ALTER ROLE
omm=# 
omm=# \du+ role3
                  List of roles
 Role name | Attributes | Member of | Description 
-----------+------------+-----------+-------------
 role3     |            | {omm}     | 

omm=# 

5.删除所有创建角色

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

drop role role10;
drop role role2;
drop role role3;