课后作业

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

CREATE ROLE role1 LOGIN Sysadmin IDENTIFIED BY 'test_123';;
CREATE ROLE role2 WITH LOGIN PASSWORD 'test_456' VALID BEGIN '2021-12-10' VALID UNTIL '2021-12-30';CREATE ROLE role1 LOGIN IDENTIFIED BY 'test_789';

2.重命名role1

ALTER ROLE role1 RENAME TO role10;

3.修改role2密码

ALTER ROLE role2 IDENTIFIED BY 'abcd@123' replace 'test_456';

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

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

5.删除所有创建角色

drop role role10;\du
drop role role2;\du+
drop role role3;