Audit event number 111 corresponds to the undeploy option of sp_webservices.
This example shows an audit table entry for the following command entered in the pubs2 database by the user bob:
sp_webservices ’undeploy’, ’all’
The corresponding audit table entry lists 111, bob, and pubs2 as values in the event, loginname, and dbname columns, respectively. The extrainfo column contains the following:
webservices_role; undeploy_all; ; ; ; ; bob/ase;
This example shows an audit table entry for the following command entered in the pubs2 database by the user bob:
sp_webservices ’undeploy’, ’rawservice’
The corresponding audit table entry lists 111, bob, and pubs2 as values in the event, loginname, and dbname columns, respectively. The extrainfo column contains the following:
webservices_role; deploy; ; ; ; ; bob/ase;
For a full description of sysaudits table columns, see the Adaptive Server Enterprise Security Administration Guide.
