Re: BUG #12939: GRANT ALL ON ALL SEQUENCES doesn't work for sequences not yet existing - Mailing list pgsql-bugs

From Stephen Frost
Subject Re: BUG #12939: GRANT ALL ON ALL SEQUENCES doesn't work for sequences not yet existing
Date
Msg-id 20150401210755.GS3663@tamriel.snowman.net
Whole thread Raw
In response to BUG #12939: GRANT ALL ON ALL SEQUENCES doesn't work for sequences not yet existing  (tyler.hale@capitalone.com)
Responses Re: BUG #12939: GRANT ALL ON ALL SEQUENCES doesn't work for sequences not yet existing  ("Hale, Tyler" <Tyler.Hale@capitalone.com>)
List pgsql-bugs
Tyler,

* tyler.hale@capitalone.com (tyler.hale@capitalone.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

pgsql-bugs by date:

Previous
From: tyler.hale@capitalone.com
Date:
Subject: BUG #12939: GRANT ALL ON ALL SEQUENCES doesn't work for sequences not yet existing
Next
From: Bruce Momjian
Date:
Subject: Re: 9.4 and reproducible "ERROR: could not read block 0 in file..."