Re: Running a query as a specific, different user

From: John DeSoi <desoi(at)pgedit(dot)com>
To: Mark Lubratt <mark(dot)lubratt(at)indeq(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Running a query as a specific, different user
Date: 2006-11-19 20:12:38
Message-ID: C7BACB49-C06F-4562-980F-5D3DE674780F@pgedit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Nov 19, 2006, at 11:10 AM, Mark Lubratt wrote:

> I'm working on a report (using jasperreports) for an application
> I've written accessing PG 8.1.4. The view I'm doing the report on
> needs to run as a the specific user requesting the report; however,
> the report is connecting to the database using a general username
> for the report itself.
>
> Is there a way within the SQL of the request to get a query to
> execute as a specific user? In effect changing the user in the
> middle of a connection?

SET SESSION AUTHORIZATION

http://www.postgresql.org/docs/current/interactive/sql-set-session-
authorization.html

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mark Lubratt 2006-11-19 20:27:15 Re: Running a query as a specific, different user
Previous Message Ron Peterson 2006-11-19 16:34:19 Re: composite type insert