Re: BUG #12939: GRANT ALL ON ALL SEQUENCES doesn't work for sequences not yet existing

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: tyler(dot)hale(at)capitalone(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #12939: GRANT ALL ON ALL SEQUENCES doesn't work for sequences not yet existing
Date: 2015-04-01 21:07:55
Message-ID: 20150401210755.GS3663@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Tyler,

* tyler(dot)hale(at)capitalone(dot)com (tyler(dot)hale(at)capitalone(dot)com) wrote:
> Running a GRANT ALL ON ALL SEQUENCES IN PUBLIC SCHEMA doesn't work when the
> sequence is created after running the GRANT statement regardless of whether
> the sequence was created implicitly or explicitly.

GRANT ALL only operates against objects which already exist.

If you wish to set default privileges, use ALTER DEFAULT PRIVILEGES.
Those will then apply for newly created objects.

Thanks!

Stephen

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2015-04-02 00:50:25 Re: 9.4 and reproducible "ERROR: could not read block 0 in file..."
Previous Message tyler.hale 2015-04-01 19:39:30 BUG #12939: GRANT ALL ON ALL SEQUENCES doesn't work for sequences not yet existing