Functions: System Privileges

Description: These are the system privileges that are related to functions.

ALTER ANY PROCEDURE
CREATE ANY PROCEDURE
CREATE PROCEDURE
debug ANY PROCEDURE
DROP ANY PROCEDURE
EXECUTE ANY PROCEDURE
 
-- these are granted and revokes by
 
GRANT EXECUTE ON <function_name> TO <schema_name>;

Enjoyed this post? Share it!

 

Leave a comment

Your email address will not be published.