cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
cancel
Showing results for 
Search instead for 
Did you mean: 

Set owner when creating a view in databricks sql

zyang
Contributor

Hi,

I would like to set the owner when create a view in databricks sql.

Is it possible? I cannot find anything about it.

Best

2 REPLIES 2

Anonymous
Not applicable

@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.

Anonymous
Not applicable

Hi @z yang​ 

Thank you for posting your question in our community! We are happy to assist you.

To help us provide you with the most accurate information, could you please take a moment to review the responses and select the one that best answers your question?

This will also help other community members who may have similar questions in the future. Thank you for your participation and let us know if you need any further assistance! 

Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.