Security Guide > Security Guide > Controlling Access through Database Procedures > How to Implement a Database Procedure
Was this helpful?
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 on page 35.
3. Invoke the database procedure by issuing an EXECUTE PROCEDURE statement or triggering a security alarm. Any user who has been granted Execute permission can perform this step.
Last modified date: 01/26/2023