Skip to main content
Create or update many Ranger policies in one request. You can fill in a table in the portal, or upload an Excel file. Each row in the table is one policy. If a policy with the same name already exists, NexusOne adds the permissions, groups, and users in that row to the policy and never replaces what the policy already has.

Prerequisites

Before starting this task, ensure you have the following: Required roles: nx1_migration_admin or nx1_migration_ops.

Bulk create policies

Perform these steps to bulk create policies.
  1. Log in to NexusOne.
  2. On the top navigation bar, hover your mouse over Govern and then select Data Access.
  3. Click the All policies tab.
  4. Click Bulk Create.
  5. Add the policies with one of the following options:
    • Table editor: Click Add Row for each policy, and fill in the columns.
    • Excel upload: Click Download template and fill in the template. Then click Excel upload, choose your .xlsx file, and review the rows that appear in the table editor.
  6. Click Submit.
  7. Review the results, which show how many policies were created, updated, and failed. For each failed policy, the results show its name and the error.
  8. Click Done, or click Add more rows to fix the failed rows and submit again.
The table has the following columns:
  • Name: The policy name.
  • Role: The role the policy applies to.
  • Database: The database, which is the catalog or schema.
  • Tables: The tables the policy covers.
  • Columns: The columns the policy covers.
  • URL: A storage location, for a storage policy.
  • Permissions: The access types to grant.
  • Groups: The groups the policy applies to.
  • Users: The users the policy applies to.
  • Item Type: Select allow, deny, allow_exception, or deny_exception.
  • Row Filter: A SQL WHERE fragment that limits the rows the policy shows.
  • Label: A label to add to the policy.
You can submit up to 500 rows at a time.

Additional resources

For an overview of the Govern feature, refer to Govern Overview.