|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 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:
|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.