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

User Managemet CRD's are missing for Postgressql

Open nrjsingh167 opened this issue 1 year ago • 1 comments

What problem are you facing?

Currently, I am using Crossplane for database provisioning along with user and permission management. When I used PostgreSQL, it missed the user creation/deletion CRDs similar to Mysql/MSSQL

How could Crossplane help solve your problem?

If this feature comes soon, then it will help us to make our end-to-end fully managed database solution built on top of crossplane compositions and providers.

nrjsingh167 avatar May 13 '24 09:05 nrjsingh167

Hi, I think you can entirely manage this with Roles in PostgreSQL.

From the manual "CREATE USER is now an alias for CREATE ROLE. The only difference is that when the command is spelled CREATE USER, LOGIN is assumed by default, whereas NOLOGIN is assumed when the command is spelled CREATE ROLE.

Bastichou avatar Jun 10 '24 19:06 Bastichou