On 12/17/14 5:37 PM, Heikki Linnakangas wrote:
On 12/15/2014 02:43 AM, Marko Tiikkaja wrote:
The syntax is:
DROP PRIVILEGES OWNED BY role [, ...]
DROP seems like the wrong verb here. DROP is used for deleting objects,
while REVOKE is used for removing permissions from them. REVOKE already
has something similar:
REVOKE ALL PRIVILEGES ON ALL TABLES IN SCHEMA public FROM heikki;
Following that style, how about making the syntax:
REVOKE ALL PRIVILEGES FROM <role>;
I don't have a problem with that. It would probably work, too, since
FROM is already fully reserved.
.marko
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
