ALTER USER chris VALID UNTIL 'May 4 12:00:00 2005 +1'; 令用户永远有效: ALTER USER fred VALID UNTIL 'infinity'; 赋予一用户创建新用户和新数据库的权限: ALTER USER miriam CREATEUSER CREATEDB
alter_user__linux命令中文解释.html
有关使用 PASSWORD 参数的详细信息,请参阅CREATE USER。 VALID UNTIL 'expiration_date' 指定密码具有过期日期。使用值'infinity'可避免密码具有过期日期。此参数的有效数据类型为时间戳。 只有超级用户才能使用此参数。 RENAME TO 重命名用户。 new_name
ALTER ROLE fred VALID UNTIL 'infinity'; 授予一个角色创建其它角色和新数据库的权限: ALTER ROLE miriam CREATEROLE CREATEDB; 给一个角色设置非缺省的maintenance_work_mem参数值: ALTER ROLE worker_bee SET maintenance_work_mem = 100000; 给一个角色设置非缺省的、指定数据库的client_min_messages参数值:...
ALTER ROLE fred VALID UNTIL 'infinity'; 让一个角色能够创建其他角色和新的数据库: ALTER ROLE miriam CREATEROLE CREATEDB; 为一个角色指定 maintenance_work_mem 参数的非默认设置: ALTER ROLE worker_bee SET maintenance_work_mem = 100000; 为一个角色指定 client_min_messages 参数的数据库相关的非默认设置...
ALTER ROLE fred VALID UNTIL 'infinity'; 授予一个角色创建其它角色和新数据库的权限: ALTER ROLE miriam CREATEROLE CREATEDB; 给一个角色设置非缺省的maintenance_work_mem参数值: ALTER ROLE worker_bee SET maintenance_work_mem = 100000; 给一个角色设置非缺省的、指定数据库的client_min_messages参数值:...
If a user-supplied value is specified for a ROWID column, Db2 uses the value only if both of the following conditions are true: The value is a valid row ID value that was previously generated by Db2. The column has a unique, single-column index. Until this index is created on the...
ALTER ROLE fred VALID UNTIL 'infinity'; 让一个角色能够创建其他角色和新的数据库: ALTER ROLE miriam CREATEROLE CREATEDB; 为一个角色指定 maintenance_work_mem 参数的非默认设置: ALTER ROLE worker_bee SET maintenance_work_mem = 100000; 为一个角色指定 client_min_messages 参数的数据库相关的非默认设置...
If a user-supplied value is specified for a ROWID column, Db2 uses the value only if both of the following conditions are true: The value is a valid row ID value that was previously generated by Db2. The column has a unique, single-column index. Until this index is created on the...
ALTER TABLE table-name [ALTER [COLUMN] column-alteration | partition-alteration] ROTATE partition-rotation [ADD column-definition] [VALIDPROC {program-name | NULL}] [AUDIT {NONE | CHANGES | ALL}] [[ADD] PRIMARY KEY key-name (column-list)] [ADD check-constraint] [ADD add-partition] [ADD...