brainly/terraform-provider-redshift

Unable to grant usage on shared database

mohrman opened this issue · 1 comments

I'm trying to grant a redshift user access to use a shared database, created from a data share.

It works when doing it directly in the database with below command, but with the terraform provider it doesn't seem to be possible.

In database:
grant usage on database myDatabase to myUser;

Error message when using the provider:
Error: Invalid privileges list [usage] for object of type database

I've also tried to grant usage to the specific schema in the database but that gives me below error:
Error: could not start transaction: pq: Cannot connect to shared database "myDatabase". Connect to the databases in your cluster instead and use cross-database query notation <shareddatabase>.<schema>.<object> to query the data in shared database.

I have a same issue