topic Re: Group vs User rights in Data Engineering

Group vs User rights

Mirko — Wed, 26 Jan 2022 16:34:12 GMT

I have a small question: How does the combination of group and user rights work? Is it like in azure, that if i have for example databricks sql acces threw a (databricks) group i am member of, but in my personal account databricks sql is not enabled -> databricks sql is enabled for me?

Re: Group vs User rights

pavan_kumar — Thu, 27 Jan 2022 07:16:58 GMT

@Mirko Ludewig

currently if the "databricks sql" is not enabled in a workspace then you cannot assign the permissions to the users for the "databricks sql access".

If you have situation where "databricks sql access" is give to the users with enabling the "databricks sql" on workspace please share us the images and details i can check it.

Re: Group vs User rights

Anonymous — Fri, 28 Jan 2022 08:49:37 GMT

Hi @Mirko Ludewig

If you are a member of a group that has databricks SQL access, you will inherit Databricks SQL access entitlement from groups. Provided your databricks account has SQL enabled.

Re: Group vs User rights

Mirko — Fri, 28 Jan 2022 08:59:43 GMT

@Pratik Bhawsar thank you for the answer, i just started to prepare a more precise question. Could you explain why some of the Options in the admin console are greyed out? e.g. i can remove workspace acces from user 3 but not from user 1.

Re: Group vs User rights

Anonymous — Fri, 28 Jan 2022 09:11:18 GMT

@Mirko Ludewig It is greyed out because the permissions are inherited from groups (possibly admin group in this case) and can not be modified on this page.

Also if admin access is provided, all other ticks are greyed out since you can’t remove any other access while still giving admin access.

Re: Group vs User rights

Mirko — Fri, 28 Jan 2022 09:32:35 GMT

that makes perfectly sense. Thank you!

Re: Group vs User rights

Anonymous — Fri, 28 Jan 2022 16:47:34 GMT

@Mirko Ludewig - Good morning (or evening depending on where you hail), would you be happy to mark whichever answer resolved the problem for you as best? That helps other members find the solutions more quickly. 🙂