All Forums Database
BlaineKinnebrew 2 posts Joined 11/14
24 Nov 2014
Execute permission

What is the difference between EXECUTE and EXECUTE PROCEDURE permission?

What is the difference between EXECUTE and EXECUTE FUNCTION permission?
Thanks,
 
Blaine
 

 

 

dnoeth 4628 posts Joined 11/04
26 Nov 2014

Hi Blaine,
GRANT EXECUTE ON object
= the right to execute a MACRO
 
GRANT EXECUTE ON PROCEDURE object or GRANT EXECUTE PROCEDURE ON object 
= the right to CALL a PROCEDURE
 
GRANT EXECUTE ON FUNCTION object or GRANT EXECUTE FUNCTION ON object 
= the right to use a FUNCTION

Dieter

BlaineKinnebrew 2 posts Joined 11/14
28 Nov 2014

Dieter,
Thank you!
Blaine

You must sign in to leave a comment.