User-defined Web services are modeled as stored procedures within Adaptive Server Enterprise. In manipulating user-defined Web services, Adaptive Server Enterprise generates the following events using the existing auditing coverage for stored procedures:
The creation of a user-defined Web service – Event 11 named "Create Procedure" is generated
The dropping of a user-defined Web service – Event 28 named "Drop Procedure" is generated
The execution of a user-defined Web service – Event 38 named "Execution of Stored Procedure" is generated
For detailed information on existing auditing functionality, see the Adaptive Server Enterprise Security Administration Guide.
In addition to existing auditing functionality, Adaptive Server Enterprise provides two audit events for the deploy and undeploy options of sp_webservices.
Audit records are stored in the sysaudits system table. You can enable auditing for Web services with the following command:
sp_audit "security", "all", "all", "on"
