Hi All,
I am trying to manage access to objects created in a Unity Catalog.
I want the owner/creator of the object(me) to not have access to the object and only the specified users/groups to be able to select/perform other actions on the objects.
But the DENY Command is not supported in Unity Catalog. Is there any other way to deny access to the owner of the objects?
The command I am using is:
%sql
DENY EXECUTE ON FUNCTION catalogName.schemaName.functionTest TO `username@email.com`;
Thanks!