Segregation of users with sentry

[Deepesh]

Hi - Can we able to control the users action on the dropping/deleting other users database/table within the same group, with having access to create/drop own database/tables in hive.

Understand Sentry works on groups but is there any way to control it at user level pls?

Thanks,

[Deepesh]

Do the request

curl -u $Credentials http7180/api/v6/timeseries?query="SELECT+integral(yarn_application_mb_millis_maps_rate)+WHERE+CATEGORY=YARN_POOL"\&from=${previous_date}\&contentType=text%2Fcsv\&desiredRollup=DAILY\&mustUseDesiredRollup=true > ${file_date}

cat $file_date

curl -u $Credentials http://bda1node03.na.pg.com:7180/api/v6/timeseries?query="SELECT+integral(yarn_application_mb_millis... > ${file_date}

[Deepesh]

FYI

################################################

import os,sys

import subprocess

import time

import os

import json

import commands

import ConfigParser

from cm_api.api_client import ApiResource

cm_host = "10..21"

api = ApiResource(cm_host, username="jteam", password="Infy123",version=8)

cdh5=None

config = ConfigParser.RawConfigParser()

config.read('/home/user1/Downloads/cm_api-master/python_dev_test/hostdeatils')

Horton=config.get("Clusterdetails","cluster_name")

hrt=Horton.split(',')

#print "GETTING/ALL/CLUSTER/DETAILS"

#get_detail= curl -s  -u admin:admin http://16.18:8080/api/v1/clusters/CoE/services/ | grep "service_name"

hrt=Horton.split(',')

for i in hrt:

        test=config.get(i,"Clustertype")

        if test == "Cloudera":

                        cdh5= None

                        for c in api.get_all_clusters():

                          if c.version == "CDH5":

                                 cdh5 = c

                        for s in cdh5.get_all_services():

                                  for chk in s.healthChecks:

                                          raj = "%s --- %s"%(chk['name'], chk['summary'])

                                          rr=""" | gawk 'BEGIN { ORS = ""; print " [ "}/Filesystem/ {next}{ printf "%s{\\"Service_name\\": \\"%s\\",\\"Status\\": \\"%s\\"}",separator,$1,$3;separator="," }END { print " ] " }' """

                                          #print rr

                                          doni =""" echo " %s " %s """%(raj,rr)

                                          #print doni

                                          pravin = subprocess.Popen(doni,stdout=subprocess.PIPE, shell=True).stdout.read()

                                          print pravin

cat /home/user1/Downloads/cm_api-master/python_dev_test/hostdeatils

[Hortonworks]

Clustername=CoE

ClusterType=Hortonworks

Namenode=mctd1t.ad.is.com

ResourceManager=mctd1t.ad.infosys.com,HistoryServer=mctd1t.ad.infosys.com

Ambari=16.18

CommandCenter=.22

Hostnames=mctd1t.com,mctd2t.ad.,mctd4t.

Clustername="Cluster 1"

ClusterType=Cloudera

User=user1

Namenode=bhucloud04.a

Hostnames=bhucloud05..com,bhucloud04.a

[Hortonworks1]

Clustername=CoE

ClusterType=Hortonworks

Namenode=mctd1t.ad.infosys.com

ResourceManager=mctd1t.com,HistoryServer=mctd1t.ad.

Ambari=1018

CommandCenter=10..22

Hostnames=mctd1t.ad.,mctd2t.ad.ins.com,mctd4t..com

[Clusterdetails]

cluster_name=Hortonworks,Cloudera,Hortonworks1

#####################################################

[Deepesh]

working on.

[Deepesh]

on it