Grant REMOTE permission

Use the following procedures to add a remote user.

 To create a remote user (Sybase Central)
  1. Use the SQL Anywhere 12 plug-in to connect to the database as a user with DBA authority.

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

  3. Choose File » 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. Use the SQL Anywhere 12 plug-in to 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