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?
-
"in side the postgres function." <-- The what??– Chris SJan 25, 2012 at 21:12
-
I mean - inside the user defined function– TripJan 25, 2012 at 21:20
-
1Yep, you can do that. Don't know why you would want to, but you can.– Chris SJan 25, 2012 at 21:25
-
Thankyou Chris Basically I have a set of Grant commands I want to write a loop and pass the table names as parameters so that the function can be very minimal– TripJan 25, 2012 at 22:32
Add a comment
|
1 Answer
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).
answered Jan 25, 2012 at 23:05
-
You are correct, as per the suggestion I wrote the external script and its working great. Thanku– TripFeb 10, 2012 at 18:57