openGauss每日一练第4天 创建、修改、更改和删除角色

1.创建角色role1为系统管理员, role2指定生效日期, role3具有LOGIN属性
root@modb:~# su - omm
omm@modb:~$ gsql -r
gsql ((openGauss 2.0.0 build 78689da9) compiled at 2021-03-31 21:03:52 commit 0 last mr )
Non-SSL connection (SSL connection is recommended when requiring high-security)
Type "help" for help.
omm=# create role role1 login sysadmin identified by 'role1_123';
NOTICE: The encrypted password contains MD5 ciphertext, which is not secure.
CREATE ROLE
omm=# create role role2 with login password 'role2_456' valid begin '2021-12-18' valid until '2021-12-30';
NOTICE: The encrypted password contains MD5 ciphertext, which is not secure.
CREATE ROLE
omm=# create role role3 login identified by 'role3_123';
NOTICE: The encrypted password contains MD5 ciphertext, which is not secure.
CREATE ROLE
omm=# \du+
List of roles
Role name | Attributes | Membe
r of | Description
-----------+------------------------------------------------------------------------------------------------------------------+------
-----+-------------
gaussdb | Sysadmin | {}
|
omm | Sysadmin, Create role, Create DB, Replication, Administer audit, Monitoradmin, Operatoradmin, Policyadmin, UseFT | {}
|
role1 | Sysadmin | {}
|
role2 | Role valid begin 2021-12-18 00:00:00+08 +| {}
|
role3 | | {}
|

| Role valid until 2021-12-30 00:00:00+08
2.重命名role1
omm=# alter role role1 rename to role10;
NOTICE: MD5 password cleared because of role rename
ALTER ROLE
3.修改role2密码
omm=# alter role role2 identified by 'adcd@123';
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=# revoke all privilege from role3;
ALTER ROLE
5.删除所有创建角色
omm=# drop role role10;
DROP ROLE
omm=# drop role role2;
DROP ROLE
omm=# drop role role3;
DROP ROLE

过程中使用\du或\du+查看角色信息
omm-# \du
List of roles
Role name | Attributes | Membe
r of
-----------+------------------------------------------------------------------------------------------------------------------+------
-----
gaussdb | Sysadmin | {}
omm | Sysadmin, Create role, Create DB, Replication, Administer audit, Monitoradmin, Operatoradmin, Policyadmin, UseFT | {}

omm-#