pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
SET SESSION AUTHORIZATION permissions
2+ messages / 2 participants
[nested] [flat]

* SET SESSION AUTHORIZATION permissions
@ 2006-09-04 11:14  Luís Sousa <llsousa@ualg.pt>
  0 siblings, 1 reply; 2+ messages in thread

From: Luís Sousa @ 2006-09-04 11:14 UTC (permalink / raw)
  To: pgsql-admin

Hi all,

I'm using PostgreSQL 7.4.7-6sarge2 (debian).

Only superuser can issue the command SET SESSION AUTHORIZATION?
Suppose this, I have created all tables in one database with a 
privileged user. On my ident config I putted that user so in interactive 
session is so simple as \c - <privileged user> to connect with that user.
When I tried to dump and the restore on command line with my user, is 
issued a SET SESSION AUTHORIZATION with a permission denied error!
Except running the script as superuser and giving superuser privileges 
to my user, what can I do on command line so that SET SESSION 
AUTHORIZATION doesn't fail?

Best regards,
Luís Sousa








^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: SET SESSION AUTHORIZATION permissions
@ 2006-09-04 15:18  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Luís Sousa <llsousa@ualg.pt>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2006-09-04 15:18 UTC (permalink / raw)
  To: Luís Sousa <llsousa@ualg.pt>; +Cc: pgsql-admin

=?ISO-8859-1?Q?Lu=EDs_Sousa?= <llsousa@ualg.pt> writes:
> Only superuser can issue the command SET SESSION AUTHORIZATION?

Well, yeah.

> When I tried to dump and the restore on command line with my user, is 
> issued a SET SESSION AUTHORIZATION with a permission denied error!

Use --no-owner if you want to make pg_dump output that won't generate
this error (and want all the restored objects to be owned by whoever
runs the script).  Or just ignore the error messages.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2006-09-04 15:18 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-09-04 11:14 SET SESSION AUTHORIZATION permissions Luís Sousa <llsousa@ualg.pt>
2006-09-04 15:18 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox