／var／logmarcus chiu

SQL - Data Control Language (DCL)

Created on · Last Modified on

SQL - Data Control Language (DCL)
  • is a type of Structured Query Language (SQL) used to control access to stored data in a database and provide data security
  • these include:
    • GRANT - grants permissions on a securable to a principal
    • REVOKE - revokes a previously granted or denied permission
    • EXECUTE AS, statement - sets the execution context of a session
    • EXECUTE AS, clause - define the execution context of the following user-defined modules: functions (except inline table-valued functions), procedures, queues, and triggers
    • REVERT - switches the execution context back to the previous one