provider-sql icon indicating copy to clipboard operation
provider-sql copied to clipboard

Grants to schema functions / custom SQL queries

Open petteja opened this issue 2 years ago • 2 comments

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.

petteja avatar Mar 18 '22 11:03 petteja