SQL Data Access and Security Privilege Options | Teradata Vantage - SQL Data Access Options - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Detailed Topics

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
imq1591724555718.ditamap
dita:ditavalPath
imq1591724555718.ditaval
dita:id
B035-1184
lifecycle
previous
Product Category
Teradata Vantage™
Option Description
CONTAINS SQL The procedure can execute SQL control statements.

The procedure neither reads nor modifies SQL data in the database.

An example is a procedure whose body consists of just control statements local to the procedure.

If such a procedure attempts to read or modify SQL data, or calls a procedure that attempts to read or modify SQL data, the system raises the following SQLSTATE exception code.

'2F004' - reading SQL-data not permitted.
MODIFIES SQL DATA The procedure can execute all SQL statements that can validly be called from an SQL procedure.

This is the default option for SQL procedures that do not specify an SQL Data Access clause when the procedure is defined.

An example of such as statement is an UPDATE, INSERT or DELETE.

READS SQL DATA The procedure cannot execute SQL statements that modify SQL data, but can execute statements that read SQL data.

An example is the FETCH statement.

If such a procedure attempts to modify SQL data, or calls a procedure that modifies database data, the system raises the following SQLSTATE exception code.

'2F002' -modifying SQL-data not permitted.