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/
- Re: [ADMIN] pg_user, changing priviliges Marcin Mazurek
- Re: [ADMIN] pg_user, changing priviliges Ross J. Reedstrom
- Re: [ADMIN] pg_user, changing priviliges Peter Eisentraut
- Re: [ADMIN] pg_user, changing priviliges Oliver Elphick