Verifying Privileges on Views, Macros, and Procedures - Analytics Database - Teradata Vantage

SQL Data Control Language

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-07-11
dita:mapPath
sgu1628111251052.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
dvv1472243528022
lifecycle
latest
Product Category
Teradata Vantageā„¢
Statement Submitted Privileges That the System Verifies
CREATE MACRO Any privileges needed to perform the SQL statements in the macro body.
CREATE PROCEDURE (SQL Form) Any privileges needed to perform the SQL statements in the procedure body.
  • CREATE PROCEDURE (External Form)
  • ALTER PROCEDURE (External Form)
CREATE EXTERNAL PROCEDURE and any privileges needed to access the specified tables, columns, and views using any of the valid API function calls.
CREATE PROCEDURE ... SQL SECURITY OWNER (both forms) CREATE OWNER PROCEDURE and either of the following:
  • For the SQL form, any privileges needed on the underlying tables, columns, and views to perform the SQL statements in the procedure body.
  • For the external form, any privileges needed on the underlying tables, columns, and views using any of the valid API function calls.
CREATE VIEW SELECT on the underlying base tables and views.

Vantage also verifies that the appropriate privileges exist on the target objects for any user who attempts to access a view, or perform a macro or procedure. This ensures that a change to a target object does not cause a violation of privileges when the view, macro, or procedure referencing that object is invoked.