Re: no privileges were granted

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: no privileges were granted
Дата
Msg-id 24612.1210687964@sss.pgh.pa.us
обсуждение исходный текст
Ответ на no privileges were granted  (Volkan YAZICI <yazicivo@ttmail.com>)
Список 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 по дате отправления:

Предыдущее
От: "Gauthier, Dave"
Дата:
Сообщение: PG -v- MySQL
Следующее
От: Tom Lane
Дата:
Сообщение: Re: DB Connections in TIME_WAIT state