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

SAP Sybase SQL Anywhere 16.0 » SQL Remote » Creating SQL Remote systems


User privileges

SQL Remote uses a consistent system to manage the users who have privileges on remote and consolidated databases.

Users of databases involved in SQL Remote replication require the MANAGE REPLICATION system privilege (part of the SYS_REPLICATION_ADMIN_ROLE system role) to GRANT or REVOKE the following privileges:

  • PUBLISH   Every database in a SQL Remote system publishes information. Therefore, every database must have a publisher. To create a publisher, grant one user PUBLISH privilege. The publisher user must be unique throughout the SQL Remote system. When sending data, the publisher represents the database. For example, when a database sends a message, its publisher user name is included with the message. When a database receives a message, it can identify the database that sent the message by the publisher name in the message.

  • REMOTE   A database, such as a consolidated database, that sends messages to other databases must specify which remote databases it sends messages to. To specify these remote databases on the consolidated database, grant REMOTE privilege to the publishers of the remote databases. REMOTE privilege identifies databases that receive messages from the current database.

  • CONSOLIDATE   Each remote database must specify the consolidated database that it receives messages from. To specify a consolidated database on the remote database, grant CONSOLIDATE privilege to the publisher of the consolidated database. A remote database can only receive messages from one consolidated database. CONSOLIDATE privilege identifies the database that sends messages to this remote database.

 Extraction utility (dbxtract) sets privileges automatically
 See also

Single-tiered hierarchy
Multi-tiered hierarchy
PUBLISH privilege
REMOTE privilege