Re: [SQL] Scripting GRANT on functions

2005-10-06 Thread Tom Lane
"Stewart Ben (RBAU/EQS4) *" <[EMAIL PROTECTED]> writes: > Is there any easy way to script granting privileges to a number of > functions? I've got as far as the following code before realising that > I'll need to pass in the arguments, and the arguments are stored as OIDs > in pg_proc. > Is there

Re: [SQL] Scripting GRANT on functions

2005-10-06 Thread Russell Simpkins
Subject: [SQL] Scripting GRANT on functions Is there any easy way to script granting privileges to a number offunctions? I've got as far as the following code before realising thatI'll need to pass in the arguments, and the arguments are stored as OIDsin pg_proc.Is there an

[SQL] Scripting GRANT on functions

2005-10-05 Thread Stewart Ben (RBAU/EQS4) *
Is there any easy way to script granting privileges to a number of functions? I've got as far as the following code before realising that I'll need to pass in the arguments, and the arguments are stored as OIDs in pg_proc. Is there any easy way, such as GRANT FUNCTION OID 12345? ---CODE---