Updated on 2025-09-18 GMT+08:00

DCL Syntax Overview

Data control language (DCL) is used to set or modify database users or role rights.

Authorization

DWS provides a statement for granting rights to data objects and roles. For details, see GRANT.

Revoking Rights

DWS provides a statement for revoking rights. For details, see REVOKE.

Setting Default Rights

DWS allows users to set rights for objects that will be created. For details, see ALTER DEFAULT PRIVILEGES.