ALTER USER modifies the attributes of a database user.Session parameters modified by ALTER USER apply to the specified user and take effect in the next session.Modify use
-name:create usercommunity.postgresql.postgresql_user:db:postgresname:testuserpassword:testpwstate:presentlogin_unix_socket:/tmpregister:created_user-name:debug created_userdebug:msg:"{{ created_user }}"-name:alter usercommunity.postgresql.postgresql_user:db:postgresname:testuserpassword:different_passwor...
ALTER ROLEname[ [ WITH ]option[ ... ] ] 这里的option可以是: SUPERUSER | NOSUPERUSER | CREATEDB | NOCREATEDB | CREATEROLE | NOCREATEROLE | CREATEUSER | NOCREATEUSER | INHERIT | NOINHERIT | LOGIN | NOLOGIN | CONNECTION LIMITconnlimit| [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password' |...
NOCREATEUSERINHERITNOINHERITLOGINNOLOGINREPLICATIONNOREPLICATIONCONNECTION LIMIT connlimitPASSWORD passwordENCRYPTEDUNENCRYPTEDVALID UNTIL 'timestamp' 这些选项修改由CREATE ROLE初始设置的属性。 要获取更多详细信息,请参阅CREATE ROLE参考页。 new_name 角色的新名字。 database_name 要设置配置变量的数据库的名称。
CURRENT_USER修改当前用户而不是一个显式标识的角色。 SESSION_USER修改当前会话用户而不是一个显式标识的角色。 SUPERUSERNOSUPERUSERCREATEDBNOCREATEDBCREATEROLENOCREATEROLEINHERITNOINHERITLOGINNOLOGINREPLICATIONNOREPLICATIONBYPASSRLSNOBYPASSRLSCONNECTION LIMIT connlimit[ ENCRYPTED ] PASSWORD ' password' PASSWORD NU...
-- Create the ds schema.gaussdb=#CREATESCHEMAds;-- Set the search path of a schema.gaussdb=#SETSEARCH_PATHTOds,public;-- Set the time/date type to the traditional postgres format (date before month).gaussdb=#SETDATESTYLETOpostgres,dmy;-- Set the character code of the current session to...
NOCREATEUSERINHERITNOINHERITLOGINNOLOGINREPLICATIONNOREPLICATIONCONNECTION LIMIT connlimitPASSWORD passwordENCRYPTEDUNENCRYPTEDVALID UNTIL 'timestamp' 这些选项修改由CREATE ROLE初始设置的属性。 要获取更多详细信息,请参阅CREATE ROLE参考页。 new_name 角色的新名字。 database_name 要设置配置变量的数据库的名称。
ALTER TABLE [ OFFLINE | [ ONLINE [ WITH ( { online_parameter = value } [, ... ] ) ] ] ] [ IF EXISTS ] { table_name [*] | ONLY table_name | ONLY ( table_name ) } action [, ... ]; ALTER TABLE [ OFFLINE | [ ONLINE [ WITH ( { online_parameter = value } [, ......
ALTER USER ALTER VIEW CLEAN CONNECTION CLOSE CLUSTER COMMENT CREATE BARRIER CREATE DATABASE CREATE FOREIGN TABLE (GDS导入导出) CREATE FOREIGN TABLE (SQL on OBS or Hadoop) CREATE FOREIGN TABLE (OBS导入导出) CREATE FUNCTION CREATE GROUP CREATE INDEX CREATE REDACTION POLICY CREATE...