no privileges were granted

Поиск
Список
Период
Сортировка
От Volkan YAZICI
Тема no privileges were granted
Дата
Msg-id 877idybsr8.fsf@alamut.mobiliz.com.tr
обсуждение исходный текст
Ответы Re: no privileges were granted
Список 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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Tomasz Ostrowski
Дата:
Сообщение: Re: rounding problems
Следующее
От: Anton Burkun
Дата:
Сообщение: Compiling trigger function with MinGW