Re: GRANT in pg7.2

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: "Anjan Dave" <adave(at)vantage(dot)com>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: GRANT in pg7.2
Date: 2003-12-17 18:38:35
Message-ID: 200312171938.35801.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Iain 2003-12-18 02:19:49 FATAL: unrecognized configuration parameter "show_statement_stats"
Previous Message Anjan Dave 2003-12-17 17:47:45 GRANT in pg7.2