Re: function privileges

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Murat Tasan <murat(dot)tasan(at)cwru(dot)edu>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: function privileges
Date: 2006-02-03 04:57:08
Message-ID: 22869.1138942628@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Murat Tasan <murat(dot)tasan(at)cwru(dot)edu> writes:
> If user A comes along and has no SELECT privileges on T, but has
> EXECUTE privileges on F, A is not permitted to run the function, with
> an error stating access to T is needed.

> Now, if user B comes along and has SELECT privileges on T, but not
> EXECUTE privileges on F, B is permitted to run the function.

I don't think I believe either of the above statements. Perhaps you
could provide a complete example of what you're doing?

regards, tom lane

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Arnaud Lesauvage 2006-02-03 09:48:45 schemas in functions
Previous Message Michael Fuhr 2006-02-03 04:49:20 Re: function privileges