pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / 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