DROP ROLE
Valid in: SQL, ESQL, OpenAPI, ODBC, JDBC, .NET
The DROP ROLE statement removes the specified role identifiers from the installation. Any session using a role identifier when the identifier is dropped continues to run with the privileges defined for that identifier.
The DROP ROLE statement has the following format:
[EXEC SQL] DROP ROLE role_id {, role_id};
role_id
Specifies an existing role identifier. If the list of role_ids contains any that do not exist, the DBMS Server returns an error for each non-existent role_id, but does not abort the statement. Others in the list that are valid, existing role identifiers, are removed.
Embedded Usage
In an embedded DROP ROLE statement, role_id cannot be represented with a host language variable.
Permissions
You must have MAINTAIN_USERS privilege and be connected to the iidbdb database.
Locking
The DROP ROLE statement locks pages in the iirole catalog in the iidbdb.
Related Statements
CREATE ROLE
ALTER ROLE
Last modified date: 01/30/2023