DROP ROLE
DROP ROLE#
Syntax#
drop_role ::=#
Prerequisites#
Only the SYS user and users with the DROP ANY ROLE system privilege can drop a role.
Description#
This statement drops the specified role.
role_name#
This is used to specify the name of the role to be dropped.
Example#
<Query> Drop the role with the name alti_role.
iSQL> DROP ROLE alti_role;
Drop success.