Inforiver
EDITable
EDITable
  • Introduction to EDITable
    • Why EDITable?
    • Supported Database Connections
  • Get Started
    • EDITable Pre-requisites
      • Admin consent for EDITable's Entra ID
        • Basic consent
        • Full admin consent
    • Install EDITable
    • Add EDITable visual
  • Getting Data into EDITable
    • Connect to Data
      • Get data
      • Assign fields
      • Configuration Steps
        • Configure source
        • Configure Columns
        • Configure Type 2 SCDs (Optional)
    • Create a Table
      • Create From Scratch
      • Use Existing Table
      • Import Data
  • Working with EDITable
    • EDITable interface
    • Manage Columns
      • General
      • Constraints
      • Lookup and Relation
      • Display
      • Import/Export Configuration
      • Add Database Column
      • Insert Column
    • Column Access Control
    • Row Identification
    • Table Operations (Insert/Update/Delete)
      • Edit data
      • Bulk Edit
      • Find and Replace
      • Insert rows
      • Insert Column
      • Import rows
      • Delete rows
      • Duplicate rows
      • Copy rows
      • Preview Changes
      • Reset Changes
    • Explore data
      • Search and filter
      • Sort and reorder
      • Show/Hide columns
      • Pin columns
      • Group Rows By
      • Summarize Column
    • Basic formatting
    • Conditional Formatting
  • Row Access Control
  • Approval Workflow
    • Review Changes - Workflow process
  • Type 2 SCDs
    • Configuring Type 2 SCDs in EDITable
  • Audit logs
  • Webhook
  • Display Settings
  • Commenting and Collaboration
    • Assign users & task status
    • View all comments & track changes
    • Comment Settings
  • Admin Portal & EDITable Console
    • Tables
    • Transaction Logs
    • Insights (Metrics)
    • Utility
      • Download Report
      • Pipeline
        • Power BI & EDITable deployment pipelines
        • Deployment in different destinations
        • Trigger deployment pipeline from external applications
        • Logs & other pipeline options
    • Manage Profile
    • Admin Portal
      • User Management
      • Settings
        • General Settings
        • Writeback Settings
          • Settings
          • EDITable managed DB
        • API token
    • Onboarding Actions
  • Formula and Functions
    • Conditional statements
      • IF
      • IFNA
      • SWITCH
    • Logical functions
      • AND
      • IN
      • ISBLANK
      • ISEMPTY
      • ISNUMBER
      • NOT
      • OR
      • XOR
    • Math functions
      • ABS
      • AVERAGE
      • AVERAGEIF
      • AVERAGEEXNEG
      • AVERAGEEXZERO
      • AVERAGEEXZERONEG
      • CEILING
      • COUNT
      • COUNTIF
      • DIVIDE
      • EVEN
      • EXP
      • FLOOR
      • LOG
      • MAX
      • MIN
      • PCT
      • POWER
    • Text formatting functions
    • Date functions
      • DATE
      • DATE.FORMAT
    • Other operators
  • Keyboard Shortcuts
  • Release Notes
    • EDITable - v1.7.5
    • EDITable - v1.7
    • EDITable - v1.6.5
    • EDITable - v1.6
Powered by GitBook
On this page
  • 1. Add
  • 2. Update
  • 3. Delete
  • Delete Type
  • 3.1. Delete row permanently
  • 3.2. Mark row as deleted

Row Access Control

PreviousConditional FormattingNextApproval Workflow

Last updated 4 months ago

Data security and integrity are critically important, especially in a collaborative environment where multiple users work on a shared database. EDITable addresses your security needs by offering row-level access control at the granular level.

You can precisely manage who can add, update, or delete rows by specifying their email IDs. This section explains how you can allow/restrict all or specific users from performing specific actions (add/update/delete) using the 'Row Access Control' in EDITable.

Columnar ACL (access control for columns) is also available in EDITable and has been explained in the section.

To manage permissions for adding, updating, and deleting rows within a table, go to Settings -> Row Access.

1. Add

  1. Enable the Add Rows toggle button to allow users to add new rows to the table.

  1. Access Control

Under the 'Apply to' section, you can choose to allow all users or only specific users in the workspace to add rows.

  • All users in this workspace: Select this option to allow all workspace users to add records.

  • Specific users in this workspace: Choose this option to allow only specific workspace users to add rows. You can enter the email IDs of the users or the AD groups you want to allow.

  1. Click on Save to apply changes.

2. Update

  1. Enable the Update Rows toggle button to allow users to modify existing rows.

  1. Access Control

Under the 'Apply to' section, you can specify the access rules for the update operation.

  • All users in this workspace: Select this option to allow all workspace users to update records.

  • Specific users in this workspace: Choose this option to allow only certain workspace users to update the rows. Enter the email IDs of the users you want to allow.

  • Rule-based access: Select this option to configure rules governing the update access to particular columns or records in the table based on specified filter criteria.

-> Click on Add Rule to add a rule.

-> Enter the rule name, the filter criteria, and the designated users who can update these rows. Click on Add.

-> You can add more filter criteria within a rule by clicking on Add filter and then combine them using AND or OR operators.

-> You can set as many rules as required and assign corresponding users for each.

  1. Click on Save to apply changes.

3. Delete

The 'Delete Rows' toggle is disabled by default.

  1. Enable the Delete Rows toggle button to allow users to delete rows from the table.

  1. Access Control

Under the 'Apply to' section, you can choose to allow all users or only specific users in the workspace to delete rows.

  • All users in this workspace: Select this option to allow all workspace users to delete records.

  • Specific users in this workspace: Choose this option to allow only specific workspace users to delete rows. You can enter the email IDs of the users or the AD groups you want to allow.

  • Rule-based access: Select this option to configure rules governing the delete access to particular columns or records in the table based on specified filter criteria.

-> Click on Add Rule to add a rule.

-> Enter the rule name, the filter criteria, and the designated users who can delete these rows. Click on Add.

-> You can add more filter criteria within a rule by clicking on Add filter and then combine them using AND or OR operators.

-> You can set as many rules as required and assign corresponding users for each.

  1. Click on Save to apply changes.

Delete Type

3.1. Delete row permanently

When you select this option, the deleted rows are removed from the table/database permanently.

3.2. Mark row as deleted

When you select this option, the deleted rows remain in the database but are marked as deleted in the table.

This is accomplished by setting a specific value to an existing column in the table when a row is deleted. For example, in the example below, we have assigned the text 'DELETED_ROW' to the deleted row's 'Active' column. The results are displayed below.

Show deleted rows

When the 'Show deleted rows' option is selected, the deleted rows are shown in the table in a greyed-out format.

When this option is unchecked, the deleted rows are hidden from the table.

You can use the audit log to keep track of all changes, including the list of deleted and soft-deleted rows.

Soft delete is not supported if Type 2 SCDs are configured in the table. Instead, the deleted rows are struck off.

In the table below, Type 2 SCDs are configured, and the deleted rows are indicated as shown below:

In addition to row-level access control, you can also set up approval workflows so that every change made by a user goes through a review and approval process. This is explained in the next section.

Choose the delete type. When you allow users to delete rows, you can let them or . Both methods are explained below in detail.

delete the rows permanently
set up a soft delete
Column Access Control
Set up row access control
Enable adding rows
Allow specific users to add rows
Save settings
Enable update option
Allow all users to update rows
Allow specific users to update rows
Add rule
Configuring criteria for a rule
Adding more criteria within a rule
Adding multiple rules
Save settings
Enable delete option
Allow all users to delete rows
Allow only specific users to delete rows
Add rule for delete access
Configuring criteria for a rule
Adding more criteria within a rule
Adding multiple rules
Choose the delete type
Save settings
Delete row permanently
Mark row as deleted
Show deleted rows
Deleted rows are hidden
Audit log