The system role webservices_role has been added to Adaptive Server Enterprise for the Web Services feature. This role is required to use the deploy and undeploy options for sp_webservices. To execute a user-defined Web service, a valid login and permissions to execute the corresponding stored procedure are required.
To create, drop, and execute user-defined Web services, you need the same privileges as are necessary to create, drop, and execute stored procedures in Adaptive Server Enterprise. See the Adaptive Server Enterprise Security Administration Guide for details on how to set the proper privileges using the grant and revoke commands.
For the most current information on security in ASE
Web Services, see the Adaptive Server Enterprise Release
Bulletin.
