protect table from being deleted

Teradata Applications
Enthusiast

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.

3 REPLIES
Senior Apprentice

Re: protect table from being deleted

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.

Enthusiast

Re: protect table from being deleted

thanks Dieter.

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

Senior Apprentice

Re: protect table from being deleted

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.