how to allow a sysid to be a superuser?

From: "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: how to allow a sysid to be a superuser?
Date: 2009-12-08 16:11:32
Message-ID: 482E80323A35A54498B8B70FF2B87980042458DD76@azsmsx504.amr.corp.intel.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi:

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")?

Thanks
-dave

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2009-12-08 16:19:59 Re: Question on "best practise" for SELECTS on inherited tables
Previous Message Julian Mehnle 2009-12-08 16:03:07 regexp_matches() quantified-capturing-parentheses oddity