Hive Revoke SELECT privilege from a Role

0 votes
Hi. I had created a hive table and had granted SELECT privilege on a column to a role. Now I want to revoke this privilege. How can I do this?
May 31, 2019 in Big Data Hadoop by Wazir
2,060 views

1 answer to this question.

0 votes

The following command can be used to revoke the SELECT privilege on a column:

REVOKE SELECT <column name> ON TABLE <table name> FROM ROLE <role name>;
answered May 31, 2019 by Shri

Related Questions In Big Data Hadoop

0 votes
1 answer

How to create a parquet table in hive and store data in it from a hive table?

Please use the code attached below for ...READ MORE

answered Jan 28, 2019 in Big Data Hadoop by Omkar
• 69,220 points
18,699 views
0 votes
1 answer

Hive: grant privileges on an object to a role

Use the GRANT <Privilege> statement to grant ...READ MORE

answered May 31, 2019 in Big Data Hadoop by Sooraj
553 views
0 votes
1 answer

How to select particular column In a table in hive?

Hive is a high-level language to analyze ...READ MORE

answered Jul 31, 2019 in Big Data Hadoop by Killian
10,279 views
0 votes
1 answer

Drop an index from a Hive table.

Hi@akhtar, You can drop an index from the ...READ MORE

answered Oct 19, 2020 in Big Data Hadoop by MD
• 95,460 points
1,630 views
+1 vote
1 answer

Hadoop Mapreduce word count Program

Firstly you need to understand the concept ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 11,380 points
11,059 views
0 votes
1 answer

hadoop.mapred vs hadoop.mapreduce?

org.apache.hadoop.mapred is the Old API  org.apache.hadoop.mapreduce is the ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 11,380 points
2,562 views
+2 votes
11 answers

hadoop fs -put command?

Hi, You can create one directory in HDFS ...READ MORE

answered Mar 16, 2018 in Big Data Hadoop by nitinrawat895
• 11,380 points
108,993 views
–1 vote
1 answer

Hadoop dfs -ls command?

In your case there is no difference ...READ MORE

answered Mar 16, 2018 in Big Data Hadoop by kurt_cobain
• 9,350 points
4,630 views
0 votes
1 answer

How to create a Hive table from sequence file stored in HDFS?

There are two SerDe for SequenceFile as ...READ MORE

answered Dec 18, 2018 in Big Data Hadoop by Omkar
• 69,220 points
5,026 views
0 votes
1 answer

Granting SELECT privilege in Hive

You can use this command to do ...READ MORE

answered May 31, 2019 in Big Data Hadoop by Umar
5,434 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP