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?
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.
Could you explain more how to grand only the CREATE TABLE right? Is this something datalab admin people need do for us?
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.