>From d12f479de845f55f77096e79fea69930bd665416 Mon Sep 17 00:00:00 2001 From: Kyotaro Horiguchi Date: Tue, 9 Sep 2014 19:26:33 +0900 Subject: [PATCH 2/2] ALTER ROLE CURRENT_USER document --- doc/src/sgml/ref/alter_role.sgml | 15 ++++++++------- doc/src/sgml/ref/alter_user.sgml | 13 +++++++------ 2 files changed, 15 insertions(+), 13 deletions(-) diff --git a/doc/src/sgml/ref/alter_role.sgml b/doc/src/sgml/ref/alter_role.sgml index 0471daa..e6f8093 100644 --- a/doc/src/sgml/ref/alter_role.sgml +++ b/doc/src/sgml/ref/alter_role.sgml @@ -21,7 +21,7 @@ PostgreSQL documentation -ALTER ROLE name [ [ WITH ] option [ ... ] ] +ALTER ROLE { name | CURRENT_USER } [ [ WITH ] option [ ... ] ] where option can be: @@ -37,12 +37,12 @@ ALTER ROLE name [ [ WITH ] password' | VALID UNTIL 'timestamp' -ALTER ROLE name RENAME TO new_name +ALTER ROLE name RENAME TO new_name -ALTER ROLE name [ IN DATABASE database_name ] SET configuration_parameter { TO | = } { value | DEFAULT } -ALTER ROLE { name | ALL } [ IN DATABASE database_name ] SET configuration_parameter FROM CURRENT -ALTER ROLE { name | ALL } [ IN DATABASE database_name ] RESET configuration_parameter -ALTER ROLE { name | ALL } [ IN DATABASE database_name ] RESET ALL +ALTER ROLE { name | CURRENT_USER | ALL } [ IN DATABASE database_name ] SET configuration_parameter { TO | = } { value | DEFAULT } +ALTER ROLE { name | CURRENT_USER | ALL } [ IN DATABASE database_name ] SET configuration_parameter FROM CURRENT +ALTER ROLE { name | CURRENT_USER | ALL } [ IN DATABASE database_name ] RESET configuration_parameter +ALTER ROLE { name | CURRENT_USER | ALL } [ IN DATABASE database_name ] RESET ALL @@ -123,7 +123,8 @@ ALTER ROLE { name | ALL } [ IN DATA name - The name of the role whose attributes are to be altered. + The name of the role whose attributes are to be + altered. CURRENT_USER matches the name of the current user. diff --git a/doc/src/sgml/ref/alter_user.sgml b/doc/src/sgml/ref/alter_user.sgml index 58ae1da..feb1197 100644 --- a/doc/src/sgml/ref/alter_user.sgml +++ b/doc/src/sgml/ref/alter_user.sgml @@ -21,7 +21,7 @@ PostgreSQL documentation -ALTER USER name [ [ WITH ] option [ ... ] ] +ALTER USER { name | CURRENT_USER } [ [ WITH ] option [ ... ] ] where option can be: @@ -32,16 +32,17 @@ ALTER USER name [ [ WITH ] connlimit | [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password' | VALID UNTIL 'timestamp' -ALTER USER name RENAME TO new_name +ALTER USER name RENAME TO new_name -ALTER USER name SET configuration_parameter { TO | = } { value | DEFAULT } -ALTER USER name SET configuration_parameter FROM CURRENT -ALTER USER name RESET configuration_parameter -ALTER USER name RESET ALL +ALTER USER { name | CURRENT_USER | ALL } [ IN DATABASE database_name ] SET configuration_parameter { TO | = } { value | DEFAULT } +ALTER USER { name | CURRENT_USER | ALL } [ IN DATABASE database_name ] SET configuration_parameter FROM CURRENT +ALTER USER { name | CURRENT_USER | ALL } [ IN DATABASE database_name ] RESET configuration_parameter +ALTER USER { name | CURRENT_USER | ALL } [ IN DATABASE database_name ] RESET ALL -- 1.7.1