Grant users to execute DML on their own tables

Database
Enthusiast

Grant users to execute DML on their own tables

Hi All,

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?

Thanks

Abhishek

2 REPLIES
Junior Contributor

Re: Grant users to execute DML on their own tables

Hi Abhishek,

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.

Enthusiast

Re: Grant users to execute DML on their own tables

Thanks Deter, you simply rock ! thank you for such a simple solution. 

Regards

Abhishek