> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]]
> Sent: 12 December 2002 16:48
> To: Dave Page
> Cc: [EMAIL PROTECTED]
> Subject: Re: [HACKERS] Problem with function permissions
>
>
> "Dave Page" <[EMAIL PROTECTED]> writes:
"Dave Page" <[EMAIL PROTECTED]> writes:
> I would not have expected public to now have execute permission. Any
> reason for this, or is it a bug?
The default permissions for functions grant execute to public; the
system is just instantiating that default when you do an explicit grant.
The origina
I had the following behaviour reported by a pgAdmin user on PostgreSQL
7.3 (reproduced here on 7.3rc1 as it's all I have right now):
dave=# create function dave.testfunc() returns int4 as 'select 1 + 2'
language sql;
CREATE FUNCTION
dave=# select proacl from pg_proc where proname = 'testfunc';
p
