I am trying to provision an extension and the permissions to use it to a role. However, I am not able to do so since the Grant resource is quite limited.
The equivalent SQL statements of what I am trying to achieve are the following.
CREATE EXTENSION postgres_fdw;
GRANT USAGE ON FOREIGN DATA WRAPPER postgres_fdw TO <role>;
However, the required GRANT cannot be translated to the current Grant spec. I tried setting the privileges to ["USAGE ON FOREIGN DATA WRAPPER postgres_fdw"], but it is not supported as it does not match the regex ^[A-Z]+$.
How could Crossplane help solve your problem?
Extend the Grant resource to support a broader set of GRANT statements.
What problem are you facing?
I am trying to provision an extension and the permissions to use it to a role. However, I am not able to do so since the Grant resource is quite limited.
The equivalent SQL statements of what I am trying to achieve are the following.
The extension could be installed like this.
However, the required GRANT cannot be translated to the current Grant spec. I tried setting the privileges to
["USAGE ON FOREIGN DATA WRAPPER postgres_fdw"]
, but it is not supported as it does not match the regex^[A-Z]+$
.How could Crossplane help solve your problem?
Extend the Grant resource to support a broader set of GRANT statements.