Required Access Rights | Teradata DSA - Required Access Rights for Database Objects - BAR - Data Stream Architecture

Teradata® DSA User Guide
Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
BAR
Data Stream Architecture
Release Number
17.20
Published
November 2022
ft:locale
en-US
ft:lastEdition
2025-12-12
dita:mapPath
bis1632417576364.ditamap
dita:ditavalPath
vwp1576617377804.ditaval
dita:id
cyv1467242268519
Product Category
Software
Teradata Tools and Utilities
Object Type Required Access Rights
Backup Restore Copy
Aggregate Function Dump Restore, Alter Function Restore, Alter Function
JAR Dump Restore, Drop Procedure Restore, Drop Procedure
External Stored Procedures Dump Restore, Alter External Procedure Restore, Alter External Procedure
Standard Function Dump Restore, Alter Function Restore, Alter Function
Function Alias

as of Analytics Database 16.20 Feature Update 1

 Dump Restore, Alter Function Restore, Alter Function
Trigger Dump Restore N/A Triggers can’t be copied
Join Index Dump Restore, Drop Table, Create Table, Restore, Drop Table
Macro Dump Restore Restore
Hash Index Dump Restore, Drop Table, Create Table Restore, Drop Table
Stored Procedure Dump Restore Restore
Queue Table Dump Restore Restore
Table Function Dump Restore, Alter Function Restore, Alter Function
Table Function (Operator) Dump Restore, Alter Function Restore, Alter Function
Table Dump Restore, Drop Table, Create Table Restore
PPI Table Dump Restore, Drop Table, Create Table Restore, Drop Table
NOPI Table Dump Restore, Drop Table, Create Table Restore
View Dump Restore Restore
Authorization Dump Restore Restore
Parser Contract Function Dump Restore Restore
System Join Index Dump Restore, Drop Table, Create Table Restore, Drop Table
SQL-H Dump Restore Restore
User Installed File (UIF) Dump Restore, Create External Procedure, Execute Procedure on the SYSUIF database is required Restore, Create External Procedure, Execute Procedure on the SYSUIF database is required
GLOP Set Dump Restore Restore