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
613 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,170 points
14,484 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
149 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
3,749 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,300 points
307 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
7,817 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
1,306 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
61,227 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,390 points
2,952 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 17, 2018 in Big Data Hadoop by Omkar
• 69,170 points
2,856 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
2,493 views