dbeaver / cloudbeaver

Cloud Database Manager
https://dbeaver.com/
Apache License 2.0
3.39k stars 370 forks source link

provided-connections.json with access to anonymous users #915

Closed guitcastro closed 3 months ago

guitcastro commented 2 years ago

Is your feature request related to a problem? Please describe. I am trying to configure cloudbeaver with a provided connection, for anonymous users. However it's not possible to automated this. I have to manual log as admin and give access to "USERS" role.

Describe the solution you'd like For the context, I work using infra as code and I am trying to use codebeaver to give teams readonly access to databases. We already deployed the cloudbeaver under an ouath2 proxy, thats why anonymous login is being used.

kseniiaguzeeva commented 2 years ago

Thank you for your intereset in CloudBeaver. We are going to add the permission configuration for provided connections via the configuration file.

marcellodesales commented 1 year ago

Any plans on this?

TatyanaSsau commented 1 year ago

@marcellodesales, sorry, for really long time to response! It is not completely dropped, but this task is in the long-term plans for our team.

Thank you for your interest in CloudBeaver!

GenLN commented 6 months ago

Hi any news on this?

LonwoLonwo commented 3 months ago

Hello @guitcastro

Looks like you can do it now.

You need to configure these two files:

https://github.com/dbeaver/cloudbeaver/wiki/Pre%E2%80%90configured-permissions-for-connections https://github.com/dbeaver/cloudbeaver/wiki/Connection-configuration#pre-configured-connections

And add them to your container.

Please let me know if it solves your request.

guitcastro commented 3 months ago

Hi @LonwoLonwo , Thanks for the response!

Just a doubt:

["test_team", "test_user"] - list of users and teams who will have access for connection.

In my case where I want to allow anonymous, which string should I put in the array? anonymous?

LonwoLonwo commented 3 months ago

Like anonymousUserTeam: "user" From this doc https://github.com/dbeaver/cloudbeaver/wiki/Server-configuration

LonwoLonwo commented 3 months ago

Could I close this ticket? Is this case solved?

guitcastro commented 3 months ago

@LonwoLonwo Yes, thank you!

LonwoLonwo commented 3 months ago

Thanks for your answer, @guitcastro and the interest in our product 🤗