Collection Contents Index DBA authority overview Next PDF

SQL Anywhere® Server - Database Administration  > 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.

DBA authority is required to create database objects with different owners.


Collection Contents Index DBA authority overview Next PDF