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

Teradata® DSA User Guide

Product
BAR
Data Stream Architecture
Release Number
17.20
Published
November 2022
Last Update
2022-11-14
Content Type
User Guide
Publication ID
B035-3150-101K
Language
English (United States)
Last Update
2022-11-14
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 Analytics Database 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