Procedures and triggers provide security by allowing users limited access to data in tables that they cannot directly examine or modify.
Triggers, for example, execute under the table privileges of the owner of the associated table, but any user with privileges to insert, update or delete rows in the table can fire them. Similarly, procedures (including user-defined functions) execute with privileges of the procedure owner, but any user granted privileges can call them. Procedures and triggers can (and usually do) have different privileges than the user ID that invoked them.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|