Ability to grant EXECUTE function
ncolomer opened this issue · 0 comments
ncolomer commented
Hello,
It would be great if we could use redshift_grant
resource to grant EXECUTE
on functions.
Redshift specifications for granting and revoking this permission are:
GRANT { EXECUTE | ALL [ PRIVILEGES ] }
ON { FUNCTION function_name ( [ [ argname ] argtype [, ...] ] ) [, ...] | ALL FUNCTIONS IN SCHEMA schema_name [, ...] }
TO { username [ WITH GRANT OPTION ] | GROUP group_name | PUBLIC } [, ...]
REVOKE [ GRANT OPTION FOR ]
EXECUTE
ON FUNCTION function_name ( [ [ argname ] argtype [, ...] ] ) [, ...]
FROM { username | GROUP group_name | PUBLIC } [, ...]
[ CASCADE | RESTRICT ]
We could do the same for procedures, which is very close.