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 » SYS_RUN_REPLICATION_ROLE system role

 

Granting the SYS_RUN_REPLICATION_ROLE system role

Grant the SYS_RUN_REPLICATION_ROLE system role to a user, allowing full access to the database and allowing them to make changes specified in the messages.

Prerequisites

You must have the SYS_REPLICATION_ADMIN_ROLE system role.

Context and remarks

Only users with the SYS_RUN_REPLICATION_ROLE system role can run SQL Remote.

In Sybase Central, the inheritance of system privileges is disabled by default: the system privileges are available only to the role, not to role grantees.

 Task
  1. In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.

  2. Double-click the database name.

  3. Double-click Users.

  4. Double-click the user name.

  5. Right-click the pane (not the user name) and select New » Granted Roles.

  6. Select SYS_RUN_REPLICATION_ROLE and click OK.

Results

The user now has the SYS_RUN_REPLICATION_ROLE system role on the database when connected from SQL Remote.

 See also