Informix Guide to SQL: Syntax SQL Statements

Use the DROP ROLE statement to remove a previously created role.

Either the DBA or a user to whom the role was granted with the WITH GRANT OPTION can issue the DROP ROLE statement.

After a role is dropped, the privileges associated with that role, such as table-level privileges or fragment-level privileges, are dropped, and a user cannot grant or enable a role. If a user is using the privileges of a role when the role is dropped, the user automatically loses those privileges.

The following statement drops the role engineer:

DROP ROLE engineer

Related statements: CREATE ROLE, GRANT, REVOKE, and SET ROLE

For a discussion of how to use roles, see the Informix Guide to SQL: Tutorial.