课后作业

连接openGauss

su - omm
gsql -r

1.创建用户

1.1创建user1具有CREATEROLE权限

CREATE USER user1 CREATEROLE PASSWORD 'user1_123';

1.2创建user2具有CREATEDB权限

CREATE USER user2 CREATEDB PASSWORD 'user2_456';

1.3创建user3（两种方法）

CREATE USER user3 PASSWORD 'user3_789';
CREATE USER user3 IDENTIFIED BY 'user3_789';

1.4查看用户是否创建成功

\du

2.修改用户属性

2.1修改用户user1密码

ALTER USER user1 IDENTIFIED BY 'USER1_123' REPLACE 'user1_123';

3.重命名用户

3.1重命名用户user2

alter user user2 rename to users2;

3.2查看用户是否重命名成功

\du

4.授权与回收权限

4.1将用户user1的权限授权给用户user3

GRANT user1 to user3;

4.2查看用户是否授权成功

\du

4.3回收user3的权限

REVOKE user1 FROM user3;

4.4查看用户是否回收权限成功

\du

5.删除用户

5.1查看已有用户

\du

5.2删除创建用户

drop user user1;
drop user users2;
drop user user3;

5.3查看用户是否删除

\du