Re: Reverting SET SESSION AUTHORIZATION command

Tom Lane wrote:
>
> The syntax that comes to mind offhand is
> SET SESSION AUTHORIZATION DEFAULT;
> but perhaps someone has a better idea.
>

Tom,

The SQL standard has already defined what should go there.
That would be CURRENT_USER, so you would have:

SET SESSION AUTHORIZATION CURRENT_USER

Note that CURRENT_USER is _not_ to be affected by a
It remains the same user that was used for the connection.

The SESSION_USER is the one that changes if you issue a SET
SESSION AUTHORIZATION (otherwise is the same as the CURRENT_USER).

P.S.: I did not name those things. Complains to the SQL std committee
:-)

--
Fernando Nasser
Red Hat Canada Ltd. E-Mail: fnasser(at)redhat(dot)com
2323 Yonge Street, Suite #300
Toronto, Ontario M4P 2C9