Previous Topic: Data Manipulation Language (DML) Cursor OperationsNext Topic: Data Manipulation Language (DML) Transaction Level Operations


Data Manipulation Language (DML) Non-cursor Operations

Statement

Authorization
Required

Authorization Implications

DELETE

DELETE access for the table or view specified in the statement (or PUBLIC must have the DELETE access right for that table or view).

SELECT access for any table or view specified in the WHERE clause (or PUBLIC must have the SELECT access right for that table or view).

None

INSERT

INSERT access for the table or view specified in the statement (or PUBLIC must have the INSERT access right for that table or view).

SELECT access for any table or view specified in the WHERE clause (or PUBLIC must have the SELECT access right for that table or view).

None

SELECT INTO

SELECT access for each table or view specified in the statement (or PUBLIC must have the SELECT access right for those tables and/or views).

None

UPDATE

UPDATE access for the table or view specified in the statement or
column-level UPDATE access for all of the columns in the Set List (or PUBLIC must have the required UPDATE access rights).

SELECT access for any table or view specified in the WHERE clause (or PUBLIC must have the SELECT access right for that table or view).

None