云数据库 GaussDB-SET ROLE:示例

时间:2023-11-01 16:22:03

示例

--创建角色paul。openGauss=# CREATE ROLE paul IDENTIFIED BY 'xxxxxxxxx';--设置当前用户为paul。openGauss=# SET ROLE paul PASSWORD 'xxxxxxxxx';--查看当前会话用户,当前用户。openGauss=# SELECT SESSION_USER, CURRENT_USER;--重置当前用户。openGauss=# RESET role;--删除用户。openGauss=# DROP USER paul;
support.huaweicloud.com/centralized-devg-v2-opengauss/devg_03_0662.html