Granting REMOTE permission

Use the following procedures to add a remote user.

Create a remote user (Sybase Central)

Use the SQL Anywhere 12 plug-in to connect to the database as a user with DBA authority.
In the left pane, click the SQL Remote Users folder.
Click File » New » SQL Remote User.
Follow the instructions in the Create Remote User Wizard.

Make an existing user a remote user (Sybase Central)

Use the SQL Anywhere 12 plug-in to connect to the database as a user with DBA authority.
In the left pane, click the SQL Remote Users folder.
Right-click the user and click Change To Remote User.
In the window, click the message type, enter an address, click the send frequency, and click OK.

Create a remote user (SQL)

Connect to the database as a user with DBA authority.
Execute a CREATE USER statement to create a user.

For example:
CREATE USER remote1;
Execute a GRANT CONNECT statement to grant the user CONNECT permission.

For example:
GRANT CONNECT TO remote1;

Execute a GRANT REMOTE statement to grant the user REMOTE permission.

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';

Granting REMOTE permission

Create a remote user (Sybase Central)

Make an existing user a remote user (Sybase Central)

Create a remote user (SQL)

See also