DCL Syntax Overview
Data control language (DCL) is used to create users and roles and set or modify database users or role rights.
SHOW
openGauss can use the SHOW command to display various object information. For details about the involved SQL statements, see Table 1.
Table 1 SQL statements related to SHOW
GRANT
The openGauss allows you to run the GRANT command to grant various permissions. For details about the involved SQL statements, see Table 2.
Table 2 SQL statements related to GRANT
REVOKE
openGauss allows you to run the REVOKE command to revoke various permissions. For details about the involved SQL statements, see Table 3.
Table 3 SQL statements related to REVOKE
KILL
openGauss allows you to run the KILL command to terminate a specified connection or SQL statements executed under the connection. The following table lists the related SQL statements.
Table 4 SQL statements related to KILL
Terminate a specified connection or an SQL statement executed under the connection. |
SET PASSWORD
openGauss allows you to run the SET PASSWORD command to change the user password. The following table lists the related SQL statements.
Table 5 SQL statements related to SET PASSWORD