I'm trying to set up RBAC for tables in my Azure Databricks workspace by following
https://docs.microsoft.com/en-us/azure/databricks/administration-guide/access-control/table-acl
I'm able to create tables, however the owner is being set to 'root' and not the user name which I'm using.
ALTER TABLE <table-name> OWNER TO <workspace-user> doesn't have any on table ownership. What could be wrong?
When table ACLs are enabled on a cluster, a user who creates a database, table, view, or function becomes its owner. The owner is granted all privileges and can grant privileges to other users.
Steps to assign owner to object:
An administrator can assign an owner to an object using the ALTER <object> OWNER TO <user-name>@<user-domain>.com command:
ALTER DATABASE <database-name> OWNER TO `<user-name>@<user-domain>.com`
ALTER TABLE <table-name> OWNER TO `<user-name>@<user-domain>.com`
ALTER VIEW <view-name> OWNER TO `<user-name>@<user-domain>.com`
To ALTER DATABASE:
To ALTER TABLE:
To ALTER VIEW:
Reference: Azure Databricks - Data object privileges.