Re: no privileges were granted - Mailing list pgsql-general

From Tom Lane
Subject Re: no privileges were granted
Date
Msg-id 24612.1210687964@sss.pgh.pa.us
Whole thread Raw
In response to no privileges were granted  (Volkan YAZICI <yazicivo@ttmail.com>)
List pgsql-general
Volkan YAZICI <yazicivo@ttmail.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

pgsql-general by date:

Previous
From: "Gauthier, Dave"
Date:
Subject: PG -v- MySQL
Next
From: Tom Lane
Date:
Subject: Re: DB Connections in TIME_WAIT state