Hi meenali
No, it is not possible. As example, I have a catalog "dspro20", where I am the owner:
In this catalog, I have a schema elt and a table "target_cities":
The owner is User dspro20@nona.company.
When I try to delete the table, I got this error message:
PERMISSION_DENIED: User is not an owner of Table 'dspro20.elt.target_cities'. SQLSTATE: 42501
You have to change ownership, to delete the table:
Now, I have to call the user dspro20 and explain, why I deleted his table ๐
