Skip to topics
tee / insights
LEARNING / SQL

DCL / Data Control Language

SQL DCL: Access control

Control who can do what on which resource. Read grants and revocations in terms of the resource, permission and recipient.

Topics in this category

Grant access

GRANT specifies permissions and their resource scope. The caller also needs permission to grant access. Check how each product identifies recipients.

Revoke access

REVOKE removes the specified grant. Check effective access afterward, including inherited permissions and other grants.