Revoking the database security administrator role

A DBSA uses the REVOKE DBSECADM statement to take away database security administrator authority from a user who previously was granted this role.

Before you begin

You must be a DBSA to revoke the DBSECADM role. You must know the login name from whom you want to revoke the DBSECADM role.

About this task

Procedure

Use the REVOKE DBSECADM statement to revoke the DBSECADM role, as described in Informix® Guide to SQL: Syntax.

Example

The following statement revokes DBSECADM authority from user sam:

REVOKE DBSECADM FROM sam;

What to do next