Open TeodorStoyanov opened 1 year ago
@TeodorStoyanov - thanks for writing this up. I apologize that we didn't get back to you sooner. Role grant is now supported. Do you still have the need for schema and priviliges?
@marksoper The new resources for cockroach_user_role_grant and cockroach_user_role_grants appear to only relate to Roles within the Cloud UI.
I believe this feature request (and something many of us are anxiously awaiting) is the ability to create non-admin SQL users and Manage SQL role grants specifically, totally separate and outside of the UI users and UI roles.
Overview
I have the following limitation with the Terraform provider for CockroachDB. We are trying to automate the creation of Database, Schema, Users and User's permissions like GRANTS and DEFAULT PRIVILEGES. Unfortunately, the Provider currently supports only the creation of Database and SQL Users.
Issue
I have tried to create the resources with the PostgreSQL Provider but there are engine compatibility issues with this provider and CockroachDB. I am receiving the following errors when trying to create the schema and the permissions:
Request
It would be nice if the CockroachDB provider is able to create these resources
postgresql_schema
postgresql_grant
postgresql_default_privileges
like the PostgreSQL Provider or make the CockroachDB compatible with Vanilla Postgresql.