Skip to main content
Administrator Guide
Last Updated: 2026-11-13
Required Permissions for Common Prism Operations

Required Permissions for Common Prism Operations

This table maps common operations to the permissions required on the relevant artifact. For standard read-only use cases, View access is sufficient. For write operations such as insert, update, truncate, delete, select, upsert, or replace, users require either:
  • Edit
    access.
  • View
    access in combination with the granular data operation permissions required for that action.
Operation
Artifact Type
Required Permissions
View Dataset
View Table
  • Dataset
  • Table
Either:
  • Edit
  • View
Edit Dataset
Edit Table
  • Dataset
  • Table
Edit
Use as DCT Source
  • Dataset
  • Table
Either:
  • Edit
  • View
Use as DCT Target
Table
Either:
  • Edit
  • View
    and
    Table Data Operation for DCT
Append Data Insert
Table
Either:
  • Edit
  • View
    and
    Insert Data
Update Data
Table
Either:
  • Edit
  • View
    and
    Update
    Data
Truncate Data
Table
Either:
  • Edit
  • View
    and
    T
    runcate Data
Delete Data
Table
Either:
  • Edit
  • View
    and
    Delete Data
Select Data
Table
Either:
  • Edit
  • View
    and
    Select Data
Upsert Data
Table
Either:
  • Edit
  • View
    and
    Insert Data and Update Data
Replace Data
Truncate and Insert
Table
Either:
  • Edit
  • View
    and
    Insert Data and Truncate Data