how to allow a sysid to be a superuser? - Mailing list pgsql-general

From Gauthier, Dave
Subject how to allow a sysid to be a superuser?
Date
Msg-id 482E80323A35A54498B8B70FF2B87980042458DD76@azsmsx504.amr.corp.intel.com
Whole thread Raw
Responses Re: how to allow a sysid to be a superuser?  (Scott Marlowe <scott.marlowe@gmail.com>)
List 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

pgsql-general by date:

Previous
From: Julian Mehnle
Date:
Subject: regexp_matches() quantified-capturing-parentheses oddity
Next
From: Merlin Moncure
Date:
Subject: Re: Question on "best practise" for SELECTS on inherited tables