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@xxxxxx ---------------------------------------------------------------
