@z yangโ :
Unfortunately, it is not possible to set the owner of a view when creating it in Databricks SQL. Unlike tables, views do not have an explicit owner property that can be set during creation.
However, you can set the owner of the underlying table(s) that the view is based on. This can be done using the ALTER TABLE command with the OWNER clause:
ALTER TABLE table_name SET OWNER TO owner_name;
If you set the owner of the underlying table(s), that owner will also have the ability to modify or drop the view. Keep in mind that if you have multiple views based on the same table, setting the owner of the table will affect all of them.
If you need more fine-grained access control over views, you can consider using Databricks RBAC (Role-Based Access Control) to manage permissions for individual users and groups. This will allow you to grant or revoke specific privileges (such as SELECT, INSERT, or DROP) for specific views to specific users or groups.
