16.20 - Verifying Privileges on Views, Macros, and Procedures - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Control Language

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Programming Reference
featnum
B035-1149-162K
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.

Teradata Database 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.