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.