GRANT in pg7.2 - Mailing list pgsql-admin

From Anjan Dave
Subject GRANT in pg7.2
Date
Msg-id 203C7FC3FF2D7A4588CE0429A87F3C9A06FEBD@vt-pe2550-001.vantage.vantage.com
Whole thread Raw
Responses Re: GRANT in pg7.2  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-admin

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.

pgsql-admin by date:

Previous
From: "David C. Brown"
Date:
Subject: Re: Question about backing up PostgreSQL databases
Next
From: Peter Eisentraut
Date:
Subject: Re: GRANT in pg7.2