Introducing SQL Anywhere Studio
  Tutorial: Replicating Data with SQL Remote
    Lesson 2: Set up the consolidated database

Add a remote user to the database

Each remote database is identified in the consolidated database by a user ID with REMOTE permissions.

When a remote user is added to a database, the message system they use and their address under that message system need to be stored along with their database user ID.

Add a remote user

1. Open the SQL Remote Users folder in the left pane.

2. Choose File > New > SQL Remote User.

   The Remote User Creation wizard appears.

3. Type the name field as the name of the new remote user, and click Next.

4. Ensure that the user is allowed to connect, and type the password field. Confirm the password by entering it again. Click Next.

5. Select DBA permissions as well as REMOTE DBA permissions for the remote user.

6. Select the File message type and enter the remote address field in the text box. Click Next.

7. Select Send Then Close. Click Next.

8. Click Finish to create the remote user.

   The remote user field appears in the SQL Remote Users folder.

Notes 

If you forget to set DBA permission in the wizard, you can set it by double-clicking the user, and checking DBA on the Authorities tab.

You have now created the users who will use this system.