The RESOURCE authority allows a user to create database objects, such as tables, views, stored procedures, and triggers. The RESOURCE authority is not inherited through group membership, and can be granted only by a user with DBA authority.
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.
Send feedback about this page via email or DocCommentXchange | Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0 |