Re: pg_user, changing priviliges

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@rice.edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St.,  Houston, TX 77005