Hi everyone,
I'm running into an issue when requesting permissions on a Unity Catalog table. Specifically, when trying to request SELECT and MODIFY privileges on a specific table, using Request for Access in Unity Catalog.
I get the following error:
the following permissions are not assignable WrappedArray(MODIFY), valid permissions are: Vector(ALL_PRIVILEGES, SELECT, APPLY_TAG, MANAGE)
From what I understand, Unity Catalog doesn't recognise MODIFY as a valid grantable permission on this object type. Instead, it seems only the following are allowed:
ALL PRIVILEGES
SELECT
APPLY_TAG
MANAGE
Question:
Is MODIFY intentionally not supported for tables in Unity Catalog?
If I need to insert/update/delete records, should I be requesting a different permission (e.g., ALL PRIVILEGES or something more granular)?
Has anyone else run into this when requesting permissions via the UI, and how did you handle it?
Any insights would be greatly appreciated!
Thanks in advance.

Thanks,
Boitumelo