โ09-27-2022 11:44 PM
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 ?
โ09-28-2022 08:03 AM
Hi, it is allowed. you can refer: https://docs.databricks.com/spark/latest/spark-sql/language-manual/sql-ref-storage-credentials.html
โ09-29-2022 03:29 AM
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.
โ10-05-2022 10:49 PM
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.
โ10-05-2022 10:54 PM
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.
โ10-05-2022 11:39 PM
@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!
โ10-06-2022 12:50 AM
@Debayan Mukherjeeโ It's the entire error, line 775 is in different file session.py which is built in package file. โ
Passionate about hosting events and connecting people? Help us grow a vibrant local communityโsign up today to get started!
Sign Up Now