"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
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
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---