On 08/03/2007 22:21, Rikard Pavelic wrote:

And for user2 to be able to execute
example.function2() and not example.function1()?

<snip>

REVOKE EXECUTE ON FUNCTION example.function1() FROM user1
don't have any affect.

Surely you mean -

  REVOKE EXECUTE ON FUNCTION example.function1() FROM user2;

- in order to achieve what you described?

Ray.

---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---------------------------------------------------------------

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

              http://archives.postgresql.org/

Reply via email to