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