Member since 
    
	
		
		
		10-20-2021
	
	
	
	
	
	
	
	
	
	
	
	
	
	
			
      
                1
            
            
                Post
            
        
                0
            
            
                Kudos Received
            
        
                0
            
            
                Solutions
            
        
			
    
	
		
		
		10-10-2022
	
		
		10:44 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 Hi ,  We want to import ranger policy from active cluster ranger to standby cluster ranger . Could you tell us how we can achieve this using sql and api  I can list policy using below command on Active cluster ranger database, could you tell us how do I insert approx. 10,000 ranger policy into standby cluster ranger database.  SELECT g.GROUP_NAME, g.DESCR group_descr, r.NAME role_name, r.DESCRIPTION role_descr,  p.NAME policy_name, p.DESCRIPTION policy_descr, p.POLICY_TEXT FROM  X_GROUP g,  X_ROLE r,  X_ROLE_REF_GROUP rg,  X_POLICY_REF_ROLE rp,  X_POLICY p  WHERE rg.GROUP_ID = g.ID  AND rg.ROLE_ID = r.ID  AND rp.ROLE_ID = r.ID  AND rp.POLICY_ID = p.ID  AND r.NAME like '%grant%'     Regards,  Gurunath 
						
					
					... View more