pg_user, changing priviliges

From: Marcin Mazurek <M(dot)Mazurek(at)poznan(dot)multinet(dot)pl>
To: pgsql-admin(at)postgresql(dot)org
Subject: pg_user, changing priviliges
Date: 2000-10-26 06:24:56
Message-ID: 20001026082456.B6461@poznan.mtl.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I'm trying to give a createuser privilige by changing pg_users, i'm logged
in as a superuser.

mtldb=# select count(*) from pg_user where usename='mtluser';
count
-------
1
(1 row)

mtldb=# update pg_user set usesuper=true, usecatupd=true where
usename='mtluser';
UPDATE 0

Why I can't do it?

tia

Marcin Mazurek

--
Kierownik Działu Systemowego
MULTINET SA o/Poznan
http://www.multinet.pl/

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Dronamraju Rajesh 2000-10-26 12:17:47 pg_atoi: error in "template1": can't parse "template1"
Previous Message Peter Eisentraut 2000-10-25 20:29:40 Re: droping unique constraint