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
rod@iol.ie
---------------------------------------------------------------