From: | "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com> |
---|---|
To: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: how to allow a sysid to be a superuser? |
Date: | 2009-12-08 20:44:09 |
Message-ID: | 482E80323A35A54498B8B70FF2B87980042458DFF2@azsmsx504.amr.corp.intel.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
It comes back...
role "joetheplumber" does not exist
The user is a sys uid on linux.
-----Original Message-----
From: Scott Marlowe [mailto:scott(dot)marlowe(at)gmail(dot)com]
Sent: Tuesday, December 08, 2009 1:26 PM
To: Gauthier, Dave
Cc: pgsql-general
Subject: Re: [GENERAL] how to allow a sysid to be a superuser?
On Tue, Dec 8, 2009 at 9:11 AM, Gauthier, Dave <dave(dot)gauthier(at)intel(dot)com> wrote:
> PG 8.3.4 on Linux.
>
> A DB was created with a privileged account which has limited access. I want
> a specific user (sysuid) to have "all" provs on this DB. In fact, I want
> this user to have "all" on all the dbs served by the PG instance. Is there
> a way to do this such that when psql is invoked in a session of that user,
> he/she automatically has "all" (wothoug havng to enter "-user theuid")?
Make them a superuser. first log into psql as a superuser and issue
this command:
alter user username superuser;
tada! they're now large and in charge of the pgsql instance and all
its databases.
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2009-12-08 20:46:51 | Re: how to allow a sysid to be a superuser? |
Previous Message | Richard Broersma | 2009-12-08 20:39:26 | Re: Implementing next 30 (or so) rows "sliding window" |