Saturday 18 August 2012

What is DCL?


DCL stands for.. Data Control Language

DCL Provides the access permission over the data which is stored in the database.

DCL Commands Includes,
  • Grant - Command will permission to the user to do specific operations.
  • Revoke - command will remove the given permission from the user.
As mentioned above, DCL commands will allow or deny the following operations..
CONNECT
SELECT
INSERT
UPDATE
DELETE
EXECUTE

No comments:

Post a Comment