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