云数据库 GaussDB-SET SESSION AUTHORIZATION:示例

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

示例

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