7. Controlling Access through Database Procedures : Working with Procedure Objects
 
Share this page                  
Working with Procedure Objects
You can perform the following basic operations on database procedures:
Create database procedures
Note:  By default, any user can create a database procedure, but this ability can be restricted using database permissions.
View existing database procedures, including the detailed properties of each individual object
Drop database procedures
In SQL, you can accomplish these tasks using the CREATE PROCEDURE, HELP PROCEDURE, and DROP PROCEDURE statements.
In Actian Director, use the Procedure button on the menu ribbon.
In VDBA, database procedures are implemented using the Procedures branch for a particular database in the Database Object Manager window.