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,
Printable View
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,
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]
GRANT AND REVOKE ARE DCL COMMANDS
TCL commands
are
COMMIT
SAVEPOINT
ROLLBACK
I think GRANT AND REVOKE ARE DCL Commands