Hi

So, I've just tested this

If I create a schema and somebody else creates a table in that schema, I can drop their table

If they create a schema along with a table in that schema

Then grant me All privileges on the table, I cannot drop it as it says I am not the owner

We also have a lot of tables that have been created and are owned by a service account

Under permissions there are a couple of AD groups and all privileges is set against them

I am in both the groups yet I cannot drop the table, nor can I control (grant) privileges

So, it is not giving me the same rights over the table

Am I doing something wrong here as it's just not working as I would expect