|
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.
DBA authority is required to create database objects with different owners.