THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!

Page History

Versions Compared

Key

This line was added.
This line was removed.
Formatting was changed.

Comment: Added some permission

Action

Select

Update

Create

Drop

Alter

Index

Lock

All

Read

Write

ReplAdmin

ServiceAdmin

Temporary UDF admin

Refresh

RW Storage

URI RWX permission

Comments

CREATE TABLE

X

X

X -for create external table – the location)

DROP TABLE

X

X

DESCRIBE TABLE

X

X

SHOW PARTITIONS

X

X

ALTER TABLE LOCATION

X

X

X - for new location

ALTER PARTITION LOCATION

X

X

X

- for new partition location

ALTER TABLE ADD PARTITION

X

X

X - for partition location

ALTER TABLE DROP PARTITION

X

X


ALTER TABLE (all of them except the ones above)

X

X

TRUNCATE TABLE

X

X

CREATE VIEW

X

X

ALTER VIEW PROPERTIES

X

X

ALTER VIEW RENAME

X

X

DROP VIEW PROPERTIES

X

X

DROP VIEW

X

X

ANALYZE

ANALYSE TABLE

X

X

SHOW DATABASES

X

X

SHOW COLUMNS

X

X

X

SHOW TABLE STATUS

X

X

X

SHOW TABLE PROPERTIES

X

X

X

CREATE TABLE AS SELECT

X

X

X

CREATE INDEX


SHOW COLUMNS	X						X

SHOW TABLE STATUS

SHOW TABLE PROPERTIES

CREATE TABLE AS SELECT

XDROP INDEX

X

X

CREATE INDEX

X

DROP INDEX

ALTER INDEX REBUILD

X

XX

ALTER INDEX PROPERTIES

XXX

LOCK DB

XX

UNLOCK DB

XX

LOCK TABLE

XX

UNLOCK TABLE

X

X

SELECT

X

X

INSERT

X

X

UPDATE

X

X

DELETE

X

X

X

LOAD

X

X

X- input location

SHOW CREATE TABLE

X

X

CREATE FUNCTION

X

X

DROP FUNCTION

XX

MSCK (metastore check)

X

X

ALTER DATABASE

X

X

CREATE DATABASE

X

X

DROP DATABASE

X

X

IMPORT

X

X

X


EXPORT

XXX

GRANT

In Ranger - User should be "ADMIN"

REVOKE

In Ranger - User should be "ADMIN"

SHOW GRANT

Not Supported

CREATE ROLE

Not Supported

DROP ROLE

Not Supported

SHOW CURRENT ROLES

Not Supported

REVOKE ROLE

Not Supported

GRANT ROLE

Not Supported

SHOW ROLE

Not Supported

SHOW ROLE GRANT

Not Supported

SHOW PRINCIPALS

Not Supported

SHOW CONF

No Ranger Auth

LIST FILE[S] , LIST JAR[S], LIST ARCHIVE[S]

No Ranger Auth

ADD FILE[S] , ADD JAR[S], ADD ARCHIVE[S]

No Ranger Auth

DELETE FILE[S] , DELETE JAR[S] , DELETE ARCHIVE[S]

No Ranger Auth

COMPILE

No Ranger Auth

DFS

Not Supported in Ranger

RESET

No Ranger Auth

SET

No Ranger Auth

SHOW FUNCTION

No Ranger Auth

DESCRIBE FUNCTION

No Ranger Auth

DROP MACRO

No Ranger Auth

CREATE MACRO

No Ranger Auth

SHOW LOCKS

No Ranger Auth

SHOW TRANSACTIONS

No Ranger Auth

EXPLAIN

No Ranger Auth

case REPLDUMP

X

case REPLSTATUS

X

RWSTORAGE

X

Read data from HDFS using hdfs

X