Auto drop specific tables in Schema

[Former Member]

Hello Experts,

A customer has some users which are bringing tables into a schema with SLT. They want those users to be able to ONLY drop the tables which they bring in. I know you can manually go to their user and assign them table specific drop privileges, under object priviledges, but I do not know a way this can be automatically done. Is this possible?

thanks,

Connor

[lbreddemann · Accepted solution]

Nope, there is no automatic way to do that if these tables all end up in the same schema.

If they choose to replicate into separate schemas, then the users could use the schema owner user to access just the tables owned by this user.

However, this whole requirement sounds as if they are using SLT for ad hoc replication, which is not exactly the main use case, I'd say. And it certainly hadn't been designed with developer-users in mind that separately pick the tables and setup the replication themselves.

Sounds a bit like the administration privileges had been given out to generously and now there is a lack of options to control the resulting situation.

[Former Member · Accepted solution]

Thank you Lars. Yes, the security controls were not really set up correctly.