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.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|