Database Security Administrator Role

The database security administrator role (DBSECADM) is required to create and maintain label-based access control security objects.

DBSECADM is a powerful server-level role that has the following responsibilities for all databases running on the IBM® Informix® installation:

• Create, drop, alter, and rename security label components
• Create, drop, and rename security policies
• Create, drop, and rename security labels
• Attach security policies to tables and detach security policies
• Grant security labels to users and revoke security labels
• Grant and revoke exemptions from security policies
• Grant and revoke the SETSESSIONAUTH privilege