Re: [ADMIN] changing privleges in pg_user/shadow

2000-02-10 Thread Peter Eisentraut
See ALTER USER. On 2000-02-10, mike focosi mentioned: > hello all, > > i am wondering if it is possible to change the attributes in pg_user and > pg_shadow for a paticular user. i can't seem to find any documentation on > 'updating' users other than createuser and dropuser. is it possible to >

Re: [ADMIN] changing privleges in pg_user/shadow

2000-02-10 Thread mike focosi
i figured it out. found the 'alter user' table documentation. seems to be what i needed. thanks for your help. mike focosi senior applications programmer golden dome media http://www.gdp.net http://www.surfmichiana.com http://www.wndu.com - Original Message - From: Karl DeBisschop <[EMAI

Re: [ADMIN] changing privleges in pg_user/shadow

2000-02-10 Thread Karl DeBisschop
>i am wondering if it is possible to change the attributes in pg_user and >pg_shadow for a paticular user. i can't seem to find any documentation on >'updating' users other than createuser and dropuser. is it possible to >change the users' attributes? for example could this doesn't seem to work:

[ADMIN] changing privleges in pg_user/shadow

2000-02-10 Thread mike focosi
hello all, i am wondering if it is possible to change the attributes in pg_user and pg_shadow for a paticular user. i can't seem to find any documentation on 'updating' users other than createuser and dropuser. is it possible to change the users' attributes? for example could this doesn't seem to