Обсуждение: 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.