REVOKE access from users

[KVNARK]

There is a use-case where we want to REVOKE access from users so that they can't run VACUUM Command on Delta Table.

Can anyone please help here.

[Priyanka_Biswas · Accepted solution]

Hello @KVNARK .​ 

We cannot specifically restrict Vacuum operation alone.

You need to remove "MODIFY" access on the table and restrict only to the "Read" (SELECT) operation

Please note if you restrict to only "read" it will also affect all the write, update, merge into, optimize, truncate including "VACUUM" operation.

Ref: https://docs.databricks.com/data-governance/table-acls/object-privileges.html