Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 » SQL Remote » Creating SQL Remote systems » User permissions » CONSOLIDATE permission

 

Grant CONSOLIDATE permission

Use the following procedures to grant CONSOLIDATE permission to a user.

It is recommended that you grant CONSOLIDATE permission to the publisher of the consolidated database.

 To specify a consolidated database (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, click the database, and then choose File » Properties.

  3. Click the SQL Remote tab.

  4. Select This Remote Database Has A Corresponding Consolidated Database.

  5. Configure the Message Type, Address, and Send Frequency settings.

  6. Click OK to close the Consolidated Database Properties window.

 To specify a consolidated database (SQL)
  1. Execute a GRANT CONNECT statement to grant CONNECT permission to the publisher of the consolidated database. See GRANT statement.

    For example:

    GRANT CONNECT TO cons;
    
  2. Execute a GRANT CONSOLIDATE statement to grant CONSOLIDATE permission to the consolidated user. See GRANT CONSOLIDATE statement [SQL Remote].

    For example, the following statement grants CONSOLIDATE permission to the hq_user user and specifies that the consolidated database uses the SMTP email system:

    GRANT CONSOLIDATE TO hq_user
    TYPE SMTP
    ADDRESS 'hq_address';

    There is no SEND clause in this GRANT CONSOLIDATE statement, so SQL Remote sends messages to the consolidated database and then stops.

    For example, the following statement grants CONSOLIDATE permission to the cons user and specifies that the consolidated database uses the FILE system:

    GRANT CONNECT TO "cons" IDENTIFIED BY SQL;
    GRANT CONSOLIDATE TO "cons" TYPE "FILE" ADDRESS 'cons';
    GRANT CONNECT TO "rem1" IDENTIFIED BY SQL;
    GRANT PUBLISH TO "rem1";
    CREATE REMOTE MESSAGE TYPE FILE ADDRESS 'rem1';
    
 See also