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.
精彩评论