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