Updated on 2023-04-03 GMT+08:00

DCL Syntax Overview

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

Authorization

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

Revoking Rights

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

Setting Default Rights

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