Re: no privileges were granted

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Volkan YAZICI <yazicivo(at)ttmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: no privileges were granted
Date: 2008-05-13 14:12:44
Message-ID: 24612.1210687964@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Volkan YAZICI <yazicivo(at)ttmail(dot)com> writes:
> test_1_5_0_0=> GRANT EXECUTE ON FUNCTION emove.emove_outgoingmessages_delete_for_commsrv() TO emove;
> WARNING: no privileges were granted for "emove_outgoingmessages_delete_for_commsrv"
> GRANT

> Does anybody have an idea about what might be causing the problem?

What this means is that the user doing the GRANT doesn't actually have
permissions to do it. (Yeah, the message pretty much sucks, but the
behavior is mandated by SQL spec.)

Most likely, you aren't the owner of the function.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jens Wilke 2008-05-13 14:14:26 Question on warm standby log shipping
Previous Message Tom Lane 2008-05-13 14:01:52 Re: Problem returning strings with pgsql 8.3.x