Auditing sp_webservices ‘deploy’

Audit event number 110 corresponds to the deploy 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 ’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;

Example 2

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