|
1 | 1 | <!-- |
2 | | -$PostgreSQL: pgsql/doc/src/sgml/ref/alter_role.sgml,v 1.11 2008/11/14 10:22:45 petere Exp $ |
| 2 | +$PostgreSQL: pgsql/doc/src/sgml/ref/alter_role.sgml,v 1.12 2009/03/28 03:26:02 momjian Exp $ |
3 | 3 | PostgreSQL documentation |
4 | 4 | --> |
5 | 5 |
|
@@ -79,19 +79,18 @@ ALTER ROLE <replaceable class="PARAMETER">name</replaceable> RESET ALL |
79 | 79 | password is <literal>MD5</>-encrypted. |
80 | 80 | </para> |
81 | 81 |
|
82 | | - <para> |
83 | | - The remaining variants change a role's session default for |
84 | | - a specified configuration variable. Whenever the role subsequently |
85 | | - starts a new session, the specified value becomes the session default, |
86 | | - overriding whatever setting is present in <filename>postgresql.conf</> |
87 | | - or has been received from the <command>postgres</command> command line. |
88 | | - (For a role without <literal>LOGIN</> privilege, session defaults have |
89 | | - no effect.) |
90 | | - Ordinary roles can change their own session defaults. |
91 | | - Superusers can change anyone's session defaults. |
92 | | - Roles having <literal>CREATEROLE</> privilege can change defaults for |
93 | | - non-superuser roles. |
94 | | - Certain variables cannot be set this way, or can only be |
| 82 | + <para> |
| 83 | + The remaining variants change a role's session default for a |
| 84 | + specified configuration variable. Whenever the role subsequently |
| 85 | + starts a new session, the specified value becomes the session |
| 86 | + default, overriding whatever setting is present in |
| 87 | + <filename>postgresql.conf</> or has been received from the postgres |
| 88 | + command line. This only happens at login time, so configuration |
| 89 | + settings associated with a role to which you've <xref |
| 90 | + linkend="sql-set-role" endterm="sql-set-role-title"> will be ignored. |
| 91 | + Superusers can change anyone's session defaults. Roles having |
| 92 | + <literal>CREATEROLE</> privilege can change defaults for non-superuser |
| 93 | + roles. Certain variables cannot be set this way, or can only be |
95 | 94 | set if a superuser issues the command. |
96 | 95 | </para> |
97 | 96 | </refsect1> |
@@ -162,6 +161,12 @@ ALTER ROLE <replaceable class="PARAMETER">name</replaceable> RESET ALL |
162 | 161 | the parameter as the role-specific value. |
163 | 162 | </para> |
164 | 163 |
|
| 164 | + <para> |
| 165 | + Role-specific variable setting take effect only at login; |
| 166 | + <xref linkend="sql-set-role" endterm="sql-set-role-title"> |
| 167 | + does not process role-specific variable settings. |
| 168 | + </para> |
| 169 | + |
165 | 170 | <para> |
166 | 171 | See <xref linkend="sql-set" endterm="sql-set-title"> and <xref |
167 | 172 | linkend="runtime-config"> for more information about allowed |
|