https://community.databricks.com/t5/data-governance/catalog-permissions/m-p/96705#M2220 <P>Hi meenali</P><P>No, it is not possible. As example, I have a catalog "dspro20", where I am the owner:</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="StefanKoch_1-1730235194173.png" style="width: 400px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/12367iD1B628C64158FCB5/image-size/medium?v=v2&amp;px=400" role="button" title="StefanKoch_1-1730235194173.png" alt="StefanKoch_1-1730235194173.png" /></span></P><P>In this catalog, I have a schema elt and a table "target_cities":</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="StefanKoch_2-1730235262207.png" style="width: 400px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/12368i167FBEE264D4C438/image-size/medium?v=v2&amp;px=400" role="button" title="StefanKoch_2-1730235262207.png" alt="StefanKoch_2-1730235262207.png" /></span></P><P>The owner is User <A href="mailto:dspro20@nona.company" target="_blank">dspro20@nona.company</A>.&nbsp;<BR /><BR />When I try to delete the table, I got this error message:&nbsp;</P><LI-CODE lang="python">PERMISSION_DENIED: User is not an owner of Table 'dspro20.elt.target_cities'. SQLSTATE: 42501</LI-CODE><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="StefanKoch_3-1730235677924.png" style="width: 400px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/12369i97629E112369FC00/image-size/medium?v=v2&amp;px=400" role="button" title="StefanKoch_3-1730235677924.png" alt="StefanKoch_3-1730235677924.png" /></span></P><P>You have to change ownership, to delete the table:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="StefanKoch_4-1730236016466.png" style="width: 400px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/12372iC8F692D510864002/image-size/medium?v=v2&amp;px=400" role="button" title="StefanKoch_4-1730236016466.png" alt="StefanKoch_4-1730236016466.png" /></span></P><P>Now, I have to call the user dspro20 and explain, why I deleted his table <span class="lia-unicode-emoji" title=":winking_face:">😉</span></P><P>&nbsp;</P> Tue, 29 Oct 2024 21:08:09 GMT Stefan-Koch 2024-10-29T21:08:09Z https://community.databricks.com/t5/data-governance/catalog-permissions/m-p/96693#M2219 <P>can catalog owner delete tables created by another user.</P> Tue, 29 Oct 2024 18:54:50 GMT https://community.databricks.com/t5/data-governance/catalog-permissions/m-p/96693#M2219 meenali 2024-10-29T18:54:50Z https://community.databricks.com/t5/data-governance/catalog-permissions/m-p/96705#M2220 <P>Hi meenali</P><P>No, it is not possible. As example, I have a catalog "dspro20", where I am the owner:</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="StefanKoch_1-1730235194173.png" style="width: 400px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/12367iD1B628C64158FCB5/image-size/medium?v=v2&amp;px=400" role="button" title="StefanKoch_1-1730235194173.png" alt="StefanKoch_1-1730235194173.png" /></span></P><P>In this catalog, I have a schema elt and a table "target_cities":</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="StefanKoch_2-1730235262207.png" style="width: 400px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/12368i167FBEE264D4C438/image-size/medium?v=v2&amp;px=400" role="button" title="StefanKoch_2-1730235262207.png" alt="StefanKoch_2-1730235262207.png" /></span></P><P>The owner is User <A href="mailto:dspro20@nona.company" target="_blank">dspro20@nona.company</A>.&nbsp;<BR /><BR />When I try to delete the table, I got this error message:&nbsp;</P><LI-CODE lang="python">PERMISSION_DENIED: User is not an owner of Table 'dspro20.elt.target_cities'. SQLSTATE: 42501</LI-CODE><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="StefanKoch_3-1730235677924.png" style="width: 400px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/12369i97629E112369FC00/image-size/medium?v=v2&amp;px=400" role="button" title="StefanKoch_3-1730235677924.png" alt="StefanKoch_3-1730235677924.png" /></span></P><P>You have to change ownership, to delete the table:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="StefanKoch_4-1730236016466.png" style="width: 400px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/12372iC8F692D510864002/image-size/medium?v=v2&amp;px=400" role="button" title="StefanKoch_4-1730236016466.png" alt="StefanKoch_4-1730236016466.png" /></span></P><P>Now, I have to call the user dspro20 and explain, why I deleted his table <span class="lia-unicode-emoji" title=":winking_face:">😉</span></P><P>&nbsp;</P> Tue, 29 Oct 2024 21:08:09 GMT https://community.databricks.com/t5/data-governance/catalog-permissions/m-p/96705#M2220 Stefan-Koch 2024-10-29T21:08:09Z