开发者

Read-only on *all* tables in postgresql (even INHERITED ones)

开发者 https://www.devze.com 2023-01-03 19:43 出处:网络
Building on how-do-you-create-a-read-only-user-in-postgresql, my situation is more complex.Each hour, new INHERITED tables are created.Any (easy?) programmatic way t开发者_Python百科o all our read-onl

Building on how-do-you-create-a-read-only-user-in-postgresql, my situation is more complex. Each hour, new INHERITED tables are created. Any (easy?) programmatic way t开发者_Python百科o all our read-only user privileges on these as well? Trigger? Cronjob that looks for new ones?


When you create a new table, make sure the access privileges are set as well.

0

精彩评论

暂无评论...
验证码 换一张
取 消