Documentation
  • The Fundamental
  • ACTIVE SYNC
    • Data Ingestion
      • Data Tracking
        • API Key Management
        • Generate Tracking ID
        • Install tracking with Tag Manager
        • Install Tracking from the Console
        • Tracking Method on Website
      • Datasource
        • MySQL
        • PostgreSQL
        • MongoDB
        • Microsoft SQL Server
        • Shopify
        • CSV
        • Google Sheets
    • Data Ingestion API
      • Data Lake
        • File upload
        • Tracking API
      • Data Warehouse
        • Batch upload
        • CSV upload
        • Tracking API
      • Data Schema Warehouse API
    • Data Integrations
      • Manage your API Key
      • Get Data using API
  • ROCKET.BI
    • Introduction
    • Data Warehouse
      • Data Management
      • Ad-hoc Query
        • Measure Schema
        • Calculated Field
      • Query Analysis
      • Relationship
    • Row-level Security
    • Dashboard
      • Dashboard Filter
      • Chart Control
        • Tab Control
        • Single Choice
        • Multiple Choice
        • Dropdown Control
        • Slicer Control
        • Date Control
        • Input Control
      • Manage Dashboard
        • Relationship
        • View and Share
        • Select Main Date Filter
        • Boost
        • Settings
        • Add Chart
        • Add Tab
        • Add Text
    • Chart Builder
      • Chart Types
        • Pie Chart
        • Column Chart
        • Bar Chart
        • Line Chart
        • Line Stock Chart
        • Pareto Chart
        • Bubble Chart
        • Scatter Chart
        • Map Chart
        • Area Chart
        • KPI Chart
        • Lollipop Chart
        • Parliament Chart
        • Funnel Chart
        • Pyramid Chart
        • Gauge Chart
        • Bullet Graph Chart
        • Heat Map Chart
        • Word Cloud Chart
        • Tree Map Chart
        • Stacked Column Chart
        • Stacked Bar Chart
        • Sankey Chart
        • Spider Web Chart
        • Wind Rose Chart
        • Histogram Chart
        • Bell Curve Chart
        • Table Chart
        • Pivot Table Chart
      • Chart Settings
        • Zoom
        • Inner chart filter
      • Chart Filters
        • Tab Filter
        • Single Choice
        • Multiple Choice
        • Dropdown Filter
        • Slicer Filter
        • Date Filter
        • Input Filter
      • Right-click Settings
        • Change date function
        • Drill down
        • Drill through
        • Use as a filter
    • SQL Query
      • Syntax
      • Functions
      • Aggregate Functions
      • Data Types
  • UNLOCK.CI
    • Unlock.CI
Powered by GitBook
On this page
  • What is Row-level Security?
  • Define Attribute Name and Value
  • Set Up Row-level Security
  • Demo
  1. ROCKET.BI

Row-level Security

Allow you to restrict access and control data visibility at the row level based on user roles or permissions

PreviousRelationshipNextDashboard

Last updated 1 year ago

What is Row-level Security?

Row-level security (RLS) is a data governance feature of Data Insider used to limit a user's access to certain data. You can define filters for each Attribute Value, and these filters restrict data access to query and view at the row level.

Define Attribute Name and Value

1. On the Main Screen, click Settings, select Organization Settings

2. Access to the User Managements section, all user's information will be displayed here.

3. Click the user name then click View Profile to set up attributes

4. Click Add Attribute: Rocket.BI allows System Administration to freely customized user attributes.

Attribute Name: the specific name for the user attribute.

Attribute Value: set a unique value for the attribute.

5. Input attribute and value. Let's go over a brief example below to better understand how to configure Row-level Permission.

Use Cases

You run an international company selling different types of items. You want to build a reporting system that each manager in charge of each sales channel should only see data related to their channel: Online or Offline.

For the Online channel manager, you input the attribute role and value online

Set Up Row-level Security

1. Select the table in the Database that you want to add RLS, then click RLS to edit

2. Enter the attribute name and choose the condition then enter the attribute value (if the condition is in or equal)

3. Click Add Filter to choose the type of filter:

  • View All: this attribute is allowed to view all the table data

  • View Nothing: this attribute is now allowed to view any data in this table

  • Custom: select the fields to show only the data that you want the attribute can access

In this case, we set up the attribute to view only Online channel. At this time, the dataset displayed on the right still shows both channels.

4. After set up the RLS, the dataset will show only filtered data based on the value of the attribute.

Demo

Here is a demo of how to set up RLS

RLS can be set up in the feature at dataset level. Data from all , , or generated from this dataset will be restricted with the value from the RLS setup.

Schema
Dashboard
Query Analysis
Data Cook