brainly/terraform-provider-redshift

Ability to grant EXECUTE function

ncolomer opened this issue · 0 comments

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.