Databricks grant update calatog catlog_name --json @privileges.json not updating privileges

[Prasad_Koneru]

Hi Team,

I am trying to update the catalog permission privileges using databricks cli command Grant by appending json file but which is not updating the prIviliges, please help on grant update command usage.

Command using :  databricks grants update catalog demo_cat --json @privileges.json 

which is listing old prIviliges only, not updating i have updated from ALL_PRIVILEGES to USE_CATALOG

privileges.json content:

{
"privilege_assignments": [
{
"principal":"mailid",
"privileges": [
"USE_CATALOG"
]
}
]
}

[Ravivarma]

Hello @Prasad_Koneru 

 If the command is not updating the privileges as expected, there could be a few reasons for this. 

Firstly, ensure that the JSON file is correctly formatted and contains the correct privilege assignments. The privileges.json file should look something like this:

{
  "privilege_assignments": [
    {
      "principal": "principal_name",
      "privileges": [
        "USE_CATALOG"
      ]
    }
  ]
}

Replace "principal_name" with the actual principal (user or group) to which you want to grant the privilege.

Secondly, make sure that you have the necessary permissions to update the privileges. If you don't have the required permissions, the command might not execute as expected.

Lastly, there could be an issue with the Databricks CLI itself. Ensure that you're using the latest version of the CLI and that it's correctly configured.