We have a temporary database where many adhoc users have write access i.e ability to create, drop , DML , select access.
Howeevr we want adhoc users can ONLY write on tables created by them , not to tables or objects created by others . How is this possible in teradata?
only grant the CREATE right on database level to the users and remove all other rights on a database level. The Creator of an object automatically gets all rights.