Use the following procedures to add a remote user.

To create a remote user (Sybase Central)

1. Connect to the database as a user with DBA authority.

2. In the left pane, select the SQL Remote Users folder.

3. From the File menu, choose New » SQL Remote User.

4. Follow the instructions in the Create Remote User Wizard.

To make an existing user a remote user (Sybase Central)

1. Connect to the database as a user with DBA authority.

2. In the left pane, select the SQL Remote Users folder.

3. Right-click the user and choose Change To Remote User.

4. In the window, select the message type, enter an address, choose the send frequency, and click OK.

To create a remote user (SQL)

1. Connect to the database as a user with DBA authority.

2. Execute a CREATE USER statement to create a user.

   For example:

   CREATE USER remote1;

3. Execute a GRANT CONNECT statement to grant the user CONNECT permission. See GRANT statement.

   For example:

   GRANT CONNECT TO remote1;

4. Execute a GRANT REMOTE statement to grant the user REMOTE permission. See GRANT REMOTE statement [SQL Remote].

   For example:

   GRANT REMOTE TO userid;

   For example, the following statement grants REMOTE permission to user S_Beaulieu, and specifies that the remote database:

   • Uses an SMTP email as its message system.

   • Sends messages using the email address s_beaulieu@acme.com:

   • Sends message daily at 10 P.M.

   GRANT REMOTE TO S_Beaulieu TYPE smtp ADDRESS 's_beaulieu@acme.com' SEND AT '22:00';

   The following statement grants REMOTE permission to user rem1, and specifies that rem1's remote database uses a FILE message system with the address rem1.

   GRANT CONNECT TO rem1 IDENTIFIED BY SQL GRANT REMOTE TO rem1 TYPE FILE ADDRESS 'rem1';

See also

• Revoke REMOTE permission