Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

INSERT only permission not working : "does not have privileges for QUERY" , _tmp_table issue ?!?!

Solved Go to solution

Re: INSERT only permission not working : "does not have privileges for QUERY" , _tmp_table

Guru

Hi @mathieu.d ,

do you think this needs to be raised as an issue/bug , or is my case that unusual (I don't think so, honestly ;) )?

Highlighted

Re: INSERT only permission not working : "does not have privileges for QUERY" , _tmp_table

Super Collaborator

I do think this is a defect. Not sure how Cloudera will see it.

 

But to be fair, this particular way of inserting data (with the VALUES syntax) into a table is pretty much limited to small testing.