Sybase SQL Remote DC38133-01-0902-01 User Manual
Chapter 10. SQL Remote Administration
Managing SQL Remote permissions
Users of a database involved in SQL Remote replication are identified by
one of the following sets of permissions:
one of the following sets of permissions:
♦
PUBLISH
A single user ID in a database is identified as the publisher
for that database. All outgoing SQL Remote messages, including both
publication updates and receipt confirmations, are identified by the
publisher user ID. Every database in a SQL Remote setup must have a
single publisher user ID, as every database in a SQL Remote setup sends
messages.
publication updates and receipt confirmations, are identified by the
publisher user ID. Every database in a SQL Remote setup must have a
single publisher user ID, as every database in a SQL Remote setup sends
messages.
♦
REMOTE
All recipients of messages from the current database, or
senders of messages to the current database, who are immediately lower
on the SQL Remote hierarchy than the current database must be granted
REMOTE permissions.
on the SQL Remote hierarchy than the current database must be granted
REMOTE permissions.
♦
CONSOLIDATE
At most one user ID may be granted CONSOLIDATE
permissions in a database. CONSOLIDATE permissions identifies a
database immediately above the current database in a SQL Remote setup.
Each database can have only one consolidated database directly above it.
database immediately above the current database in a SQL Remote setup.
Each database can have only one consolidated database directly above it.
Information about these permissions are held in the SQL Remote system
tables, and are independent of other database permissions.
tables, and are independent of other database permissions.
Granting and revoking PUBLISH permissions
When a database sends a message, a user ID representing that database is
included with the message to identify its source to the recipient. This user ID
is the publisher user ID of the database. A database can have only one
publisher. You can find out who the publisher of an Adaptive Server
Anywhere database is at any time in Sybase Central by opening the Users &
Groups folder.
included with the message to identify its source to the recipient. This user ID
is the publisher user ID of the database. A database can have only one
publisher. You can find out who the publisher of an Adaptive Server
Anywhere database is at any time in Sybase Central by opening the Users &
Groups folder.
A publisher is required even for read-only remote databases within a
replication system, as even these databases send confirmations to the
consolidated database to maintain information about the status of the
replication. The GRANT PUBLISH statement for remote Adaptive Server
Anywhere databases is carried out automatically by the database extraction
utility.
replication system, as even these databases send confirmations to the
consolidated database to maintain information about the status of the
replication. The GRANT PUBLISH statement for remote Adaptive Server
Anywhere databases is carried out automatically by the database extraction
utility.
Granting and revoking
PUBLISH permissions
from Sybase Central
PUBLISH permissions
from Sybase Central
You can grant PUBLISH permissions on an Adaptive Server Anywhere
database from Sybase Central. You must connect to the database as a user
with full system or database administrator permissions.
database from Sybase Central. You must connect to the database as a user
with full system or database administrator permissions.
201