Auditing sp_webservices ‘undeploy’

Audit event number 111 corresponds to the undeploy option of sp_webservices.

Example 1

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;

Example 2

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 System Administration Guide.