search

crossplane-contrib / provider-sql

An SQL provider for @crossplane
https://crossplane.io
Apache License 2.0
104 stars 59 forks source link

User Managemet CRD's are missing for Postgressql #175

Open nrjsingh167 opened 4 months ago

nrjsingh167 commented 4 months ago

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.

Bastichou commented 3 months ago

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.