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