| 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: | Whole Thread | Raw Message | 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.
| 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 |