Thread: Additional Super User account(s)

Additional Super User account(s)

From
"K.T."
Date:
Anyone know of a way to assign super user priviledges to other accounts
without taking away Postgres' priviledges?  I am trying to set up a Power
User account that will allow for "COPY TO" directly to a file...

Thanx in Advance

-Kane



Re: [GENERAL] Additional Super User account(s)

From
Bruce Momjian
Date:
> Anyone know of a way to assign super user priviledges to other accounts
> without taking away Postgres' priviledges?  I am trying to set up a Power
> User account that will allow for "COPY TO" directly to a file...

Modify pg_shadow directly.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026