From: | "David Johnston" <polobo(at)yahoo(dot)com> |
---|---|
To: | "'Carlos Mennens'" <carlos(dot)mennens(at)gmail(dot)com> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Remove Role Membership |
Date: | 2011-02-04 19:22:13 |
Message-ID: | 00a401cbc4a0$d4233640$7c69a2c0$@yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Carlos Mennens
Sent: Friday, February 04, 2011 12:52 PM
To: pgsql-general(at)postgresql(dot)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(at)postgresql(dot)org) To make
changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
From | Date | Subject | |
---|---|---|---|
Next Message | Carlos Mennens | 2011-02-04 19:28:13 | Re: Additional Grants To SuperUser? |
Previous Message | David Johnston | 2011-02-04 19:18:25 | Re: Additional Grants To SuperUser? |