tristan tristantreb
tristantreb
/ read-access.sql
Created
June 5, 2023 16:35
— forked from oinopion/read-access.sql
How to create read only user in PostgreSQL
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- Create a group | |
| CREATE ROLE readaccess; | |
| -- Grant access to existing schemas & tables, and to future tables (as of now you can't grant access to future schemas) | |
| DO | |
| $do$ | |
| DECLARE | |
| sch text; | |
| BEGIN | |
| FOR sch IN |