Sybase DC38133-01-0902-01 manual To add a remote user, Add publications and subscriptions

Chapter 4. Tutorials for Adaptive Server Anywhere Users

❖To add a remote user

1.Select the SQL Remote Users folder.

2.From the File menu, choose New ➤ SQL Remote User. The Create a New Remote User wizard appears.

3.Create a remote user with user ID field_user with the following options:

♦Enter the password field_pwd .

♦Ensure that Remote DBA authority is selected, so that the user can run the Message Agent.

♦Select the message type FILE, and enter the address field .

As with the publisher address, the address of the remote user is taken relative to the SQLREMOTE environment variable or registry entry. As you have not set this value, the address is taken relative to the directory from which the Message Agent is run. You should run the Message Agent from your tutorial directory for the addresses to be interpreted properly.

☞ For information about setting the SQLREMOTE value, see “Setting message type control parameters” on page 214 .

♦Ensure that the Send Then Close option is selected.

(In many production environments you would not choose Send Then Close, but it is convenient for this tutorial.)

4.When you have finished, click Finish to create the remote user. You have now created the users who will use this system.

Add publications and subscriptions

This section describes how to add a publication to a database, and how to add a subscription to that publication for a user. The publication replicates all rows of the table SalesRep and some of the rows of the Customer table.

❖To add a publication

1.Select the Publications folder in the left pane.

2.From the File menu, choose New ➤ Publication. The Publication Creation wizard appears.

3.Name the publication SalesRepData.

4.On the Tables tab, select SalesRep from the list of Available Tables. Click Add.

The table appears in the list of Selected Tables on the right.

37