Re: GRANT SELECT ON ALL TABLES IN SCHEMA... doesn't apply to new tables?

Larry Rosenman <[email protected]> Fri, 14 Dec 2018 21:36:13 -0600
Newsgroups gmane.comp.db.postgresql.sql
Message-ID <[email protected]>
On Fri, Dec 14, 2018 at 08:26:42PM -0700, David G. Johnston wrote:
> On Friday, December 14, 2018, Larry Rosenman <[email protected]> wrote:
> >
> > Is this a bug or do I/should I re-issue the GRANT when we add tables?
> >
> 
> See:   https://www.postgresql.org/docs/11/sql-alterdefaultprivileges.html
> 
Thank You, Sir!  Exactly what I was looking for.


> David J.

-- 
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 214-642-9640                 E-Mail: [email protected]
US Mail: 5708 Sabbia Drive, Round Rock, TX 78665-2106
signature.asc (application/pgp-signature, 679 B)
-----BEGIN PGP SIGNATURE-----

iQHABAABCgCqFiEEHjgknedhWzvJgwVzaXyZsatIp30FAlwUdqwsFIAAAAAAFQAO
cGthLWFkZHJlc3NAZ251cGcub3JnbGVyQGxlcmN0ci5vcmdfFIAAAAAALgAoaXNz
dWVyLWZwckBub3RhdGlvbnMub3BlbnBncC5maWZ0aGhvcnNlbWFuLm5ldDFFMzgy
NDlERTc2MTVCM0JDOTgzMDU3MzY5N0M5OUIxQUI0OEE3N0QACgkQaXyZsatIp32M
IQgAkmla3OUpP9rc2GD+rmPRVTNBSZKIHvXj8K2u955FOIg87TX1ZbZ9ghKW0Obh
e+zJQY4WlJvqypykM04Q9CwO/oYuOTgt0Qoas/c0efwCNpjzOG0CkxcXyyB6zLbF
eNUke6zjNj+DMtpxRa4Ms+HL/aOCshc9/J8JJcnYIrXIcpaGUHIcUZF8pib3QFb+
EEEfJnYR2uIo/Bx0Va/Nt8hu5HH5Pr5xjj/cKoDO3w4eyQS4abJWBcD0Uvxpeleg
utlgGbPnof/fkyvNpPpufninnnTm7vlzv6eUfnC8m85+Z8EIYhxoETGvBDpQWVSm
WukAFgNHbnzzTDuinl9cemgbrA==
=kbQM
-----END PGP SIGNATURE-----