Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » User and database security » Data security » Security: Use views and procedures to limit data users can access


Security: Procedures and Triggers

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.

 See also