GRANT in pg7.2

[Anjan Dave]

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.

[Peter Eisentraut]

Post by Anjan Dave
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.

Post by Anjan Dave
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.


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org