Postgres Pro
Downloads
Home   >   mailing lists

Re: GRANT ON ALL IN schema - Mailing list pgsql-hackers

From Tom Lane
Subject Re: GRANT ON ALL IN schema
Date
Msg-id 343.1255372939@sss.pgh.pa.us
Whole thread Raw
In response to Re: GRANT ON ALL IN schema  (Petr Jelinek <pjmodos@pjmodos.net>)
Responses Re: GRANT ON ALL IN schema  (Jaime Casanova <jcasanov@systemguards.com.ec>)
Re: GRANT ON ALL IN schema  (Brendan Jurd <direvus@gmail.com>)
List pgsql-hackers
Tree view 
Petr Jelinek <pjmodos@pjmodos.net> writes:
> [ latest GRANT ALL patch ]

I started looking at this, and the first thing I noticed was that it
adds TABLES, FUNCTIONS, and SEQUENCES as unreserved keywords.  Now
I'm not a fan of bloating the parser that way, but I have to admit
that "GRANT ON ALL TABLE IN SCHEMA" wouldn't read well.  What I am
wondering is whether we should not go back and adjust the syntax
for the default-ACLs patch to use the same keywords, ie not

ALTER DEFAULT PRIVILEGES ... GRANT ... ON TABLE TO ...

but

ALTER DEFAULT PRIVILEGES ... GRANT ... ON TABLES TO ...

Comments?
        regards, tom lane

pgsql-hackers by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Is FOR UPDATE an optimization fence?
Next
From: Simon Riggs
Date:
Subject: Re: EvalPlanQual seems a tad broken