KingbaseESV8用户管理

create user user01  password '111111';  --可以登录

ALTER USER user01 PASSWORD '111111';

alter user user01 createdb;

create role role01 password '111111';  --无法登录

GRANT SELECT ON TABLE t01 TO role01;

GRANT role01 TO user01;   --多个用户以逗号分隔

CREATE USER schdba;

CREATE SCHEMA schema01 AUTHORIZATION schdba;

ALTER SCHEMA schema01 OWNER TO system;

ALTER SCHEMA schema01 RENAME TO schema02;

drop schema schema02 cascade;  --递归删除

test=# SHOW search_path;
   search_path   
-----------------
 "$user", public
(1 行记录)

test=# \echo :USER
system
test=# 

--上面语句部分来自官方文档