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

Teradata® DSA User Guide

Product
BAR
Data Stream Architecture
Release Number
17.05
Published
September 2020
Language
English (United States)
Last Update
2021-04-02
dita:mapPath
ihc1599061140065.ditamap
dita:ditavalPath
vwp1576617377804.ditaval
dita:id
B035-3150
lifecycle
previous
Product Category
Software
Teradata Tools and Utilities
Object Type Required Access Rights
Backup Restore Copy
Aggregate Function Dump Restore, Alter Function Restore, Create Table, Alter Function, Create View
JAR Dump Restore, Drop Procedure Restore, Create Table, Drop Procedure
External Stored Procedures Dump Restore, Alter External Procedure Restore, Create Table, Alter External Procedure
Standard Function Dump Restore, Alter Function Restore, Create Table, Alter Function, Create View
Function Alias

as of Advanced SQL Engine 16.20 Feature Update 1

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