SQL – Data Control Language

SQL – Data Control Language:

DCL Commands are used to control the access of data and other objects in the RDBMS system.

Common Commands:

  • GRANT - Grant or allow specified users to perform specified tasks.
  • REVOKE - Revoke or cancel previously granted or denied permissions.

The following privileges can be GRANTED TO or REVOKED FROM a user or role:
* CONNECT
* SELECT
* INSERT
* UPDATE
* DELETE
* EXECUTE
* USAGE

163 views

Return to top