Execute permission

Database

Execute permission

What is the difference between EXECUTE and EXECUTE PROCEDURE permission?

What is the difference between EXECUTE and EXECUTE FUNCTION permission?

Thanks,

Blaine


Tags (2)
2 REPLIES
Senior Apprentice

Re: Execute permission

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

Re: Execute permission

Dieter,

Thank you!

Blaine