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 Anywhere Server - Database Administration » User and database security » User security (roles and privileges) » Upgrading to role-based security


Changes to REMOTE DBA

In pre-16.0 databases, REMOTE DBA authority allowed a user to perform replication and synchronization operations using dbremote and dbmlsync.

The REMOTE DBA authority has been replaced by the SYS_RUN_REPLICATION_ROLE system role. Change your applications to grant this role, instead of REMOTE DBA. The GRANT REMOTE DBA statement syntax is still supported but deprecated.

Another replication-related role has also been introduced: the SYS_REPLICATION_ADMIN_ROLE system role. This role allows user to administer replication.

 See also

GRANT REMOTE DBA statement (deprecated)