Databricks Community

parthsalvi · ‎09-27-2022

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 ?

Debayan · ‎09-28-2022

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

parthsalvi · ‎09-29-2022

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.

Debayan · ‎10-05-2022

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.

parthsalvi · ‎10-05-2022

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.

Debayan · ‎10-05-2022

@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!