gp集群数据库-创建只读用户并赋查询权限
CREATE ROLE select_user login password 'Js_gp123!@#'; 或者下面都可以: CREATE USER select_user WITH PASSWORD 'Js_gp123!@#'; 把USAGE权限给到select_user grant usage on schema smartinsight to select_user; #单独赋查询的权...
CREATE ROLE select_user login password 'Js_gp123!@#'; 或者下面都可以: CREATE USER select_user WITH PASSWORD 'Js_gp123!@#'; 把USAGE权限给到select_user grant usage on schema smartinsight to select_user; #单独赋查询的权...