Previous Topic: SQL Statements and SQL Security Access RightsNext Topic: Data Manipulation Language (DML) Non-cursor Operations


Data Manipulation Language (DML) Cursor Operations

Statement

Authorization
Required

Authorization Implications

CLOSE

None

None

DECLARE CURSOR

None

None

DELETE

DELETE

None

FETCH

None (CA Datacom/DB checks access rights at cursor OPEN.)

None

OPEN

SELECT access for each table or view specified in the SELECT 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 PUBLIC must have the UPDATE access right for that table or view).

None