Ubuntu manuals

Provided by: manpages-zh_1.5.2-1_all

NAME

       SET SESSION AUTHORIZATION -

SYNOPSIS

       SET [ SESSION | LOCAL ] SESSION AUTHORIZATION username
       SET [ SESSION | LOCAL ] SESSION AUTHORIZATION DEFAULT
       RESET SESSION AUTHORIZATION

DESCRIPTION

         SQL  username

           "setuid"

       SESSION  LOCAL  SET [set(7)]

       DEFAULT  RESET

EXAMPLES

       SELECT SESSION_USER, CURRENT_USER;

        session_user | current_user
       --------------+--------------
        peter        | peter

       SET SESSION AUTHORIZATION 'paul';

       SELECT SESSION_USER, CURRENT_USER;

        session_user | current_user
       --------------+--------------
        paul         | paul

COMPATIBILITY

        SQL  username   PostgreSQL  "username" SQL  SQL  PostgreSQL

       Postgresql  <laser@pgsqldb.org>