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

时间:2025-02-12 15:08:26

示例

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