Support DefaultPrivileges

[gogovan-vincentngai]

What problem are you facing?

I would like to grant permission for Postgresql database
From my understard , if we only grant permission to the database without DefaultPrivileges
new created table will not have the permission
However when i check the doc ,it seems does not support this
https://doc.crds.dev/github.com/crossplane-contrib/provider-sql/postgresql.sql.crossplane.io/Database/[email protected]
For Terraform it does have this
https://registry.terraform.io/providers/cyrilgdn/postgresql/latest/docs/resources/postgresql_default_privileges

[olikyr]

@gogovan-vincentngai and Joaquín Fernández Campo, do we really need to define "object" privileges using the provider? As for my understanding, the provider could help us define the database and its owner (and schemas is a nice to have); From this point on, projects will rely on db management tools like liquibase as soon as you give them a database owner.
Idk if you agree with me on this point? What would be the use case where the provider should also manage privileges on tables?