provider-sql
provider-sql copied to clipboard
Grants to schema functions / custom SQL queries
What problem are you facing?
We're using RDS for PostgreSQL and after using provider-sql to install aws_s3 extension we have to grant usage to the extension manually.
grant all on all functions in schema aws_s3 to <user>;
How could Crossplane help solve your problem?
Does it make sense to implement functionallity in extension.postgresql
to give grants? Or have possibility to define custom queries which is run when reconciling? I know a few other use-cases where running custom SQL makes sense, like revoke all on database <database> from public
after creating a database.