Regarding Data Control Language

[nukavarapu]

I want to know, whether Grant and Revoke are Data Control Language commands or DDL Commands. Can any one clarify, regarding the DDL, Transaction Control Language Commands and DCL.


Thank you,

[Kancha]

GRANT and REVOKE are DDL Commands

Transaction Control Commands are
COMMIT
ROLLBACK
SAVEPOINT
SET TRANSACTION


[Edited by Kancha on 03-23-2001 at 12:21 PM]

[shaju]

GRANT AND REVOKE ARE DCL COMMANDS

TCL commands
are
COMMIT
SAVEPOINT
ROLLBACK

[yveso]

I think GRANT AND REVOKE ARE DCL Commands