no privileges were granted

From: Volkan YAZICI <yazicivo(at)ttmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: no privileges were granted
Date: 2008-05-13 06:52:27
Message-ID: 877idybsr8.fsf@alamut.mobiliz.com.tr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

When I try to grant execution permissions of a function to a role,
PostgreSQL warns that "no privileges were granted"
(backend/catalog/aclchk.c:221).

test_1_5_0_0=> \df+ emove.emove_outgoingmessages_delete_for_commsrv
List of functions
-[ RECORD 1 ]-------+-------------------------------------------
Schema | emove
Name | emove_outgoingmessages_delete_for_commsrv
Result data type | trigger
Argument data types |
Volatility | volatile
Owner | emove
Language | plpgsql
Source code |
: BEGIN
: DELETE FROM commsrv.outgoingmessages
: WHERE messageid = OLD.messageid;
:
: RETURN OLD;
: END;
:
Description |

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? By
the way, is there any (preferably psql) shortcut to list permissions of
a function?

Regards.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message J. Manuel Velasco - UBILIBET 2008-05-13 07:00:49 change encoding
Previous Message Tomasz Ostrowski 2008-05-13 06:40:41 Re: rounding problems