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

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
Language
English (United States)
Last Update
2024-04-03
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905
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 makes sure 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.