Granting the Database Security Administrator role

A DBSA uses the GRANT DBSECADM statement to give database security administrator authority to a user.

You must be a DBSA to grant DBSECADM.

Grant the DBSECADM role by issuing the GRANT DBSECADM statement, as described in the HCL Informix® Guide to SQL: Syntax.

The following statement gives DBSECADM authority to user sam:

GRANT DBSECADM TO sam;