Data Server Login Names

Data server login names are used with a client application to connect to a data server. A database administrator creates and manages data server login accounts.

Client access to replicated copies of tables is also managed by the Database Administrator. Since Sybase recommends that replicated tables be read-only, clients may be permitted to view replicated data but should be prevented from inserting, deleting, or updating rows.

To modify a table, a client must have a login name on the data server where the primary data is stored as well as the permissions necessary to update the primary data.

To modify replicated tables, a client must modify the primary data so that the Replication Server can distribute the changes to replicate databases that have subscriptions for the data. To modify a table, a client must have a login name on the data server where the primary data is stored as well as the permissions necessary to update the primary data.