Drop Role Statement
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. For more information about role identifiers, see the Ingres Database Administrator Guide.
This statement has the following syntax:
drop role role_id {, role_id};