Data Manipulation Language (DML) Transaction Level Operations

Statement	Authorization Required	Authorization Implications
COMMIT WORK	None	None
LOCK TABLE	SELECT access to the table for a shared lock. UPDATE access to the table for an exclusive lock.	None
ROLLBACK WORK	None	None

Statement

Authorization
Required

Authorization Implications

COMMIT WORK

None

LOCK TABLE

SELECT access to the table for a
shared lock.

UPDATE access to the table for an exclusive lock.

None

ROLLBACK WORK

None