It appears from my GUI admin program that: REVOKE group-role FROM user-role;
Should do the trick. >From the documentation for "REVOKE": http://www.postgresql.org/docs/9.0/static/sql-revoke.html REVOKE [ ADMIN OPTION FOR ] role_name [, ...] FROM role_name [, ...] [ CASCADE | RESTRICT ] David J -----Original Message----- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Carlos Mennens Sent: Friday, February 04, 2011 12:52 PM To: pgsql-general@postgresql.org Subject: [GENERAL] Remove Role Membership I've been searching the documentation and I've tried ALTER ROLE, REVOKE, etc etc etc & can't seem to find anything that shows me how to remove membership roles from a particular user / role. I've granted a user name 'david' a member of 'finance' role but how do I remove the role membership from 'david'? Sorry for sounding completely dumb but I just can't seem to find this in the documentation. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
