| From: | Oliver Jowett <oliver(at)opencloud(dot)com> |
|---|---|
| To: | Rob Kirkbride <rob(at)rkcomputing(dot)co(dot)uk> |
| Cc: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: Switching user within connection. |
| Date: | 2005-11-23 10:57:51 |
| Message-ID: | 43844B2F.1010309@opencloud.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
Rob Kirkbride wrote:
> Is there a standard way (or indeed a special way in Postgres) to switch
> user/password without creating a new connection?
> You can obviously do it within psql with \c but I wondered whether there
> was a way in JDBC?
There is no standard JDBC way I know of, short of reconnecting.
AFAIK there's no way at the protocol level to reauthenticate as a
different user on an existing connection. I believe psql's \c command
actually establishes a new connection.
If you originally connected as the database superuser you could use SET
SESSION AUTHORIZATION to get a similar effect; see
http://www.postgresql.org/docs/8.1/static/sql-set-session-authorization.html.
-O
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oliver Jowett | 2005-11-23 11:00:12 | Re: Can PostgreSQL do data type automated casting in |
| Previous Message | Rob Kirkbride | 2005-11-23 10:08:20 | Switching user within connection. |