Apply "revoke all on database mydb from public;" after creating mydb - In general, we need revoke functionalities (Revoke resource).

[olikyr]

What problem are you facing?

I need to find a way to apply a revoke on default privileges after db creation. "revoke all on database mydb from public;"

How could Crossplane help solve your problem?

• Implement a revoke resource, similar to grant resource, which will manage this functionality. or
• Allow GRANT object to take an empty array (or "NONE" keyword) that means no privileges are set. spec: deletionPolicy: Orphan forProvider: database: mydb databaseRef: name: mydb privileges: [] role: PUBLIC providerConfigRef: name: default-sql-postgres-provider-config a change of logic inside func createGrantQueries(gp v1alpha1.GrantParameters, ql *[]xsql.Query) would be necessary.