Audit event number 110 corresponds to the deploy 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 ’deploy’, ’all’
The corresponding audit table entry lists 110, bob, and pubs2 as values in the event, loginname, and dbname columns, respectively. The extrainfo column contains the following:
webservices_role; deploy_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 ’deploy’, ’rawservice’
The corresponding audit table entry lists 110, 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.
