ASA Database Administration Guide
Managing User IDs and Permissions
Database permissions overview
RESOURCE authority is the permission to create database objects, such as tables, views, stored procedures, and triggers. RESOURCE authority may be granted only by the DBA.
To create a trigger, a user needs both RESOURCE authority and ALTER permissions on the table to which the trigger applies.