Thread: changing privleges in pg_user/shadow
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 work: mydb=>update pg_user set usecreatedb = 'f' where usename = 'mike'; the result is 0 records updated. any help or pointers to some documention on this is greatly appreciated. thanks -mike mike focosi senior applications programmer golden dome media http://www.gdp.net http://www.surfmichiana.com http://www.wndu.com
>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: > >mydb=>update pg_user set usecreatedb = 'f' where usename = 'mike'; pg_user is anon-updatable view. If you are a superuser, however, you can update pg_shadow. -- Karl DeBisschop <kdebisschop@alert.infoplease.com> 617.832.0332 (Fax: 617.956.2696) Information Please - your source for FREE online reference http://www.infoplease.com - Your Ultimate Fact Finder http://kids.infoplease.com - The Great Homework Helper Netsaint Plugins Development http://netsaintplug.sourceforge.net
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 <kdebisschop@range.infoplease.com> To: <mike@goldendome.com> Cc: <pgsql-admin@postgreSQL.org> Sent: Thursday, February 10, 2000 1:53 PM Subject: Re: [ADMIN] changing privleges in pg_user/shadow > > >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: > > > >mydb=>update pg_user set usecreatedb = 'f' where usename = 'mike'; > > pg_user is anon-updatable view. > > If you are a superuser, however, you can update pg_shadow. > > -- > Karl DeBisschop <kdebisschop@alert.infoplease.com> > 617.832.0332 (Fax: 617.956.2696) > > Information Please - your source for FREE online reference > http://www.infoplease.com - Your Ultimate Fact Finder > http://kids.infoplease.com - The Great Homework Helper > > Netsaint Plugins Development > http://netsaintplug.sourceforge.net >
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 > change the users' attributes? for example could this doesn't seem to work: > > mydb=>update pg_user set usecreatedb = 'f' where usename = 'mike'; > > the result is 0 records updated. > > any help or pointers to some documention on this is greatly appreciated. > > thanks > -mike > > mike focosi > senior applications programmer > golden dome media > http://www.gdp.net > http://www.surfmichiana.com > http://www.wndu.com > > > ************ > > -- Peter Eisentraut Sernanders väg 10:115 peter_e@gmx.net 75262 Uppsala http://yi.org/peter-e/ Sweden