云数据库 GAUSSDB-ALTER SESSION:语法格式

时间：2025-06-03 09:37:12

云数据库 GAUSSDB

语法格式

设置会话的事务参数。

ALTER SESSION SET [ SESSION CHARACTERIS TICS  AS ] TRANSACTION
    { ISOLATION LEVEL { READ COMMITTED | READ UNCOMMITTED } } | { READ ONLY  | READ WRITE } } [, ...] ;

点击放大

设置会话的其他运行时参数。

ALTER SESSION SET 
    {{config_parameter { { TO  | =  }  { value | DEFAULT } | FROM CURRENT }} 
      | CURRENT_SCHEMA { TO | = } { schema | DEFAULT  }
      | TIME ZONE time_zone
      | SCHEMA 'schema'      
| NAMES encoding_name
      | ROLE role_name PASSWORD 'password'
      | SESSION AUTHORIZATION { role_name PASSWORD 'password' | DEFAULT }
      | XML OPTION { DOCUMENT | CONTENT }
    } ;

点击放大