Lu, Huayi e6fa411af0 DWS DEV 830.201 version

Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com>
Co-authored-by: Lu, Huayi <luhuayi@huawei.com>
Co-committed-by: Lu, Huayi <luhuayi@huawei.com>

2024-05-16 07:24:04 +00:00

4.3 KiB

Raw Permalink Blame History

DROP ROLE

Function

DROP ROLE deletes a specified role.

Precautions

If a "role is being used by other users" error is displayed when you run DROP ROLE, it might be that threads cannot respond to signals in a timely manner during the CLEAN CONNECTION process. As a result, connections are not completely cleared. In this case, you need to run CLEAN CONNECTION again.

Syntax

1
DROP ROLE [ IF EXISTS ] role_name [, ...];

Parameter Description

IF EXISTS
Sends a notice instead of an error if the specified role does not exist.
role_name
Specifies the name of the role to be deleted.

Value range: An existing role.

Examples

Delete the manager role:

1
DROP ROLE manager;

Helpful Links

CREATE ROLE, ALTER ROLE, SET ROLE

Parent topic: DDL Syntax

4.3 KiB Raw Permalink Blame History