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:
- Editaccess.
- Viewaccess in combination with the granular data operation permissions required for that action.
Operation | Artifact Type | Required Permissions |
|---|---|---|
View Dataset View Table |
| Either:
|
Edit Dataset Edit Table |
| Edit
|
Use as DCT Source |
| Either:
|
Use as DCT Target | Table | Either:
|
Append Data Insert | Table | Either:
|
Update Data | Table | Either:
|
Truncate Data | Table | Either:
|
Delete Data | Table | Either:
|
Select Data | Table | Either:
|
Upsert Data | Table | Either:
|
Replace Data Truncate and Insert | Table | Either:
|