topic Re: GRANT permission not working on Storage Credential using DBR 11.2 Shared mode in Data Engineering

GRANT permission not working on Storage Credential using DBR 11.2 Shared mode

parthsalvi — Wed, 28 Sep 2022 06:44:23 GMT

We were trying to update permissions of Storage credential using DBR 11.2 Shared mode but running into following issue Operation not allowed: GRANT(line 1, pos 0)

PFA complete error in file.

Is the above issue with cluster permission or changing permission is not allowed ?

Re: GRANT permission not working on Storage Credential using DBR 11.2 Shared mode

parthsalvi — Thu, 29 Sep 2022 10:29:44 GMT

Hi @Debayan Mukherjee @Kaniz Fatma , I was able to grant permissions using SQL script but when I use Storage Credential using DBR 11.2 Shared mode it's throwing above issue.

I've used the same cluster to update permissions for catalog, schemas and tables that's working fine.

Re: GRANT permission not working on Storage Credential using DBR 11.2 Shared mode

parthsalvi — Thu, 06 Oct 2022 05:54:01 GMT

Hi @Debayan Mukherjee I've attached error in file named grant_error. Please check in above response. I'll create a support case for the same.

Re: GRANT permission not working on Storage Credential using DBR 11.2 Shared mode

parthsalvi — Thu, 06 Oct 2022 07:50:17 GMT

@Debayan Mukherjee It's the entire error, line 775 is in different file session.py which is built in package file.

Re: GRANT permission not working on Storage Credential using DBR 11.2 Shared mode

Debayan — Wed, 28 Sep 2022 15:03:32 GMT

Hi, it is allowed. you can refer: https://docs.databricks.com/spark/latest/spark-sql/language-manual/sql-ref-storage-credentials.html

Re: GRANT permission not working on Storage Credential using DBR 11.2 Shared mode

Debayan — Thu, 06 Oct 2022 05:49:40 GMT

Hi @Parth Salvi , could you please paste the full error here, also, it is better to create a support case with Databricks with the whole error.

Re: GRANT permission not working on Storage Credential using DBR 11.2 Shared mode

Debayan — Thu, 06 Oct 2022 06:39:30 GMT

@Parth Salvi Thanks for the confirmation. I have seen the error, it looks like few of the lines were skipped, as I can see after line number 1, line number 775 has been appeared. We would like to see the whole error here to triage further. Thank you!