Contents Index DBA authority overview Ownership permissions overview

ASA Database Administration Guide
  Managing User IDs and Permissions
    Database permissions overview

RESOURCE authority 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.


Contents Index DBA authority overview Ownership permissions overview