Postgres function to loop GRANT statements

Question

I have a number of GRANTs I need to make in a Postgres databas -- Is it possible to put statements like

GRANT SELECT ON TABLE tablename_xxx TO xxx_group;

inside of a Postgres SQL function?

Answer 1

I believe you can do this, but in practice you are probably better off writing an external script to do it instead: Having a Postgres function (pl/pgsql or similar) hanging around just to do GRANTs is overkill, where a simple shell script (or PowerShell if you're on Windows) could do the job.

I consider GRANT to be part of the DDL functionality of Postgres, and it's generally a good practice to not write functions that use DDL statements (Just as you would probably not write a function to create tables).