diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2002-05-06 19:47:30 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2002-05-06 19:47:30 +0000 |
| commit | 282278899379a3a57fbc734bda6a4dc9cec3ce60 (patch) | |
| tree | 624a0a024c5361836c8b1e1dd0030c99a5329e80 /src/backend/commands/variable.c | |
| parent | 15162aef24353215bc13b3d3b645d7065d5a58df (diff) | |
| download | postgresql-282278899379a3a57fbc734bda6a4dc9cec3ce60.tar.gz postgresql-282278899379a3a57fbc734bda6a4dc9cec3ce60.zip | |
Accept SET SESSION AUTHORIZATION DEFAULT and RESET SESSION AUTHORIZATION
to reset session userid to the originally-authenticated name. Also,
relax SET SESSION AUTHORIZATION to allow specifying one's own username
even if one is not superuser, so as to avoid unnecessary error messages
when loading a pg_dump file that uses this command. Per discussion from
several months ago.
Diffstat (limited to 'src/backend/commands/variable.c')
| -rw-r--r-- | src/backend/commands/variable.c | 16 |
1 files changed, 15 insertions, 1 deletions
diff --git a/src/backend/commands/variable.c b/src/backend/commands/variable.c index 301a3c86a74..de42538bd63 100644 --- a/src/backend/commands/variable.c +++ b/src/backend/commands/variable.c @@ -9,7 +9,7 @@ * * * IDENTIFICATION - * $Header: /cvsroot/pgsql/src/backend/commands/variable.c,v 1.65 2002/04/22 15:13:53 thomas Exp $ + * $Header: /cvsroot/pgsql/src/backend/commands/variable.c,v 1.66 2002/05/06 19:47:30 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -815,6 +815,15 @@ reset_server_encoding(void) } +static bool +show_session_authorization(void) +{ + elog(INFO, "Current session authorization is '%s'", + GetUserName(GetSessionUserId())); + return TRUE; +} + + /* SetPGVariable() * Dispatcher for handling SET commands. @@ -902,6 +911,8 @@ GetPGVariable(const char *name) show_server_encoding(); else if (strcasecmp(name, "seed") == 0) show_random_seed(); + else if (strcasecmp(name, "session_authorization") == 0) + show_session_authorization(); else if (strcasecmp(name, "all") == 0) { ShowAllGUCConfig(); @@ -935,6 +946,8 @@ ResetPGVariable(const char *name) reset_server_encoding(); else if (strcasecmp(name, "seed") == 0) reset_random_seed(); + else if (strcasecmp(name, "session_authorization") == 0) + SetSessionAuthorization(NULL); else if (strcasecmp(name, "all") == 0) { reset_random_seed(); @@ -942,6 +955,7 @@ ResetPGVariable(const char *name) reset_client_encoding(); reset_datestyle(); reset_timezone(); + /* should we reset session authorization here? */ ResetAllOptions(false); } |