Thread: 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.

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-owner@postgresql.org
[mailto:pgsql-general-owner@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