Thread: GRANT in pg7.2

Hi,

I need some help for the following:

Is there a way I can assign EXECUTE privilege for a user-defined function in the GRANT command in 7.2? (7.3 has it)

Also, how do I list all the user-defined functions/stored procedures. Once listed, how to give UPDATE privilege to a user on all of them?

Appreciate any help.

Thanks,
Anjan

**************************************************************************
This e-mail and any files transmitted with it are intended for the use of the addressee(s) only and may be confidential and covered by the attorney/client and other privileges.  If you received this e-mail in error, please notify the sender; do not disclose, copy, distribute, or take any action in reliance on the contents of this information; and delete it from your system. Any other use of this e-mail is prohibited.

Anjan Dave wrote:
> Is there a way I can assign EXECUTE privilege for a user-defined
> function in the GRANT command in 7.2? (7.3 has it)

No.

> Also, how do I list all the user-defined functions/stored procedures.
> Once listed, how to give UPDATE privilege to a user on all of them?

Functions don't have an UPDATE privilege.