All Forums Teradata Applications
wangguojie2006 8 posts Joined 09/13
08 May 2014
protect table from being deleted

Hi all,
we are using data lab to store some tables. so accedentally people can drop other people's table. Is there any solution that prevent that from happening? Can i create a table that only myself can delete?
many thanks.

dnoeth 4628 posts Joined 11/04
09 May 2014

People usually drop tables because the lab db is running out of perm space and then it's not "accidentially", it's "let's look for big tables created by others" :-)
The solution is to grant only the CREATE TABLE right on those databases, but not DROP TABLE.
When a table is created the creator automatically gets all rights including DROP, but he doesn't have any access to other users tables.

Dieter

wangguojie2006 8 posts Joined 09/13
09 May 2014

thanks Dieter.
Could you explain more how to grand only the CREATE TABLE right? Is this something datalab admin people need do for us?

dnoeth 4628 posts Joined 11/04
09 May 2014

Is this done using Viewpoint's DataLab portlet? I never worked with that, so I don't know the available options.
If it's done manually, it's just granting CREATE TABLE instead of TABLE or revoking DROP TABLE afterwards.
 

Dieter

You must sign in to leave a comment.