GRANT in pg7.2

From: "Anjan Dave" <adave(at)vantage(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: GRANT in pg7.2
Date: 2003-12-17 17:47:45
Message-ID: 203C7FC3FF2D7A4588CE0429A87F3C9A06FEBD@vt-pe2550-001.vantage.vantage.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Eisentraut 2003-12-17 18:38:35 Re: GRANT in pg7.2
Previous Message David C. Brown 2003-12-17 17:29:42 Re: Question about backing up PostgreSQL databases