Previous Topic: SQL ProceduresNext Topic: Trigger Execution for Record-at-a-Time Maintenance


External Security Support for Procedure/Trigger Creation and Execution

Users executing on externally secured systems cannot create, execute, or drop procedures or triggers if the appropriate access rights have not been granted to them. Plan security secures procedure and trigger execution in CA Datacom/DB Version 10.0. CREATE PROCEDURE, CREATE TRIGGER, DROP PROCEDURE and DROP TRIGGER are secured using the DTADMIN external access.