7. Controlling Access through Database Procedures : How to Implement a Database Procedure
Share this page                  
How to Implement a Database Procedure
To implement a database procedure, follow these basic steps:
1. Create the procedure using the CREATE PROCEDURE statement. You can do this interactively or in Embedded SQL. (In VBDA, use the appropriate Procedures branch in the Database Object Manager window.)
2. Grant Execute permission on the database procedure to specified users, groups, or roles, as described in Object Permissions.
3. Invoke the database procedure by issuing an EXECUTE PROCEDURE statement, firing a rule, or triggering a security alarm. Any user who has been granted Execute permission can perform this step.