Skip to content
This repository has been archived by the owner on Jan 17, 2025. It is now read-only.

Unable to grant usage on shared database #99

Open
mohrman opened this issue Dec 6, 2022 · 1 comment
Open

Unable to grant usage on shared database #99

mohrman opened this issue Dec 6, 2022 · 1 comment
Labels
bug Something isn't working good first issue Good for newcomers

Comments

@mohrman
Copy link

mohrman commented Dec 6, 2022

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.

@yevheniilukashov
Copy link

I have a same issue

@winglot winglot added bug Something isn't working good first issue Good for newcomers labels Jan 17, 2023
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
bug Something isn't working good first issue Good for newcomers
Projects
None yet
Development

No branches or pull requests

3 participants