All Forums Database
Abhishek_RC 12 posts Joined 09/14
03 Apr 2015
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

dnoeth 4628 posts Joined 11/04
03 Apr 2015

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.

Dieter

Abhishek_RC 12 posts Joined 09/14
03 Apr 2015

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

You must sign in to leave a comment.