Hello @KaranamS 

Thank you for your inputs. Here you have provided mechanism for table delete/drop.

But however, I am look for a more dire scenario where the schema or the parent catalog is dropped.

In a decentralized platform, there are catalog owners who have full access on their catalog.

One way I can think of is disabling delete on parent catalog and applying further governance rules.

However, in any case, I am looking for a solution or mechanism to restore accidental drops on catalog or schema altogether including the structure, permissions and other artifacts within the schema/catalog.