Alters a Web service.
ALTER SERVICE service-name [ TYPE 'service-type-string' ] [ attributes ] [ AS statement' ]
[ AUTHORIZATION { ON | OFF } ] [ SECURE { ON | OFF } ] [ USER user-name | NULL } ] [ URL [ PATH ] { PATH ] { ON | OFF | ELEMENTS } ] [ USING ( SOAP-prefix | NULL } ]
{ ‘RAW’ | ‘HTML’ | ‘XML’ | ‘SOAP’ | ’DISH’ }
CREATE SERVICE tables TYPE 'HTML'
ALTER SERVICE tables AUTHORIZATION OFF USER DBA AS SELECT * FROM SYS.ISYSTAB
After executing these statements, use any Web browser to open the URL http://localhost/tables.
The ALTER SERVICE statement causes the database server to act as a Web server.
If authorization is ON, all users must provide a user name and password. Optionally, you might limit the users that are permitted to use the service by providing a user or role name using the USER clause. If the user name is NULL, all known users can access the service.
The default value is ON. It is recommended that production systems be run with authorization turned on and that you grant permission to use the service by adding users to a role.
It is strongly recommended that all services run in production systems define a statement. The statement can be NULL only if authorization is enabled.
SQL—Vendor extension to ISO/ANSI SQL grammar.
Sybase—Not supported by Adaptive Server Enterprise.
Requires the MANAGE ANY WEB SERVICE system privilege.