Sample Header Ad - 728x90

Postgres Specific table access

0 votes
3 answers
346 views
We have a requirement in our Postgres Database, We want to give specific table permissions to a particular set of user, we also have airflow in our environment which syncs tables, but sometimes any new columns are added to a table so we have to drop the table, due to which the specific table access for the user is gone. Access to a specific table is given through GRANT. Can you guys suggest us a way in which specific table access can be given, and will remain if the table is dropped and recreated?
Asked by Jatin Bisht (3 rep)
Dec 3, 2020, 06:42 AM
Last activity: Jan 25, 2025, 12:04 PM