Lists: | pgsql-admin |
---|
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 |
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/
From: | "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: pg_user, changing priviliges |
Date: | 2000-10-26 15:08:18 |
Message-ID: | 20001026100818.A29490@rice.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-admin |
On Thu, Oct 26, 2000 at 08:24:56AM +0200, Marcin Mazurek wrote:
> I'm trying to give a createuser privilige by changing pg_users, i'm logged
> in as a superuser.
>
>
> Why I can't do it?
>
reedstrm=> \d pg_user
View = pg_user
...
Because pg_user is a view on pg_shadow. Can't update a view. The right
way to go about adding createuser privilage to a user is:
ALTER USER foouser CREATEUSER;
Ross
--
Ross J. Reedstrom, Ph.D., <reedstrm(at)rice(dot)edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
---|---|
To: | Marcin Mazurek <M(dot)Mazurek(at)poznan(dot)multinet(dot)pl> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: pg_user, changing priviliges |
Date: | 2000-10-26 16:27:56 |
Message-ID: | Pine.LNX.4.21.0010261827420.767-100000@peter.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-admin |
Marcin Mazurek writes:
> I'm trying to give a createuser privilige by changing pg_users, i'm logged
> in as a superuser.
You need to change pg_shadow.
--
Peter Eisentraut peter_e(at)gmx(dot)net http://yi.org/peter-e/