There are two variables in the transaction log component database object names:
prefix – represents the one- to three-character string value of the pdb_xlog_prefix parameter (the default is ra_).
xxx – represents an alphanumeric counter, a string of characters that is (or may be) added to a database object name to make that name unique in the database.
The value of the pdb_xlog_prefix parameter is the prefix string used in all Replication Agent object names. The value of the pdb_xlog_prefix_chars parameter is a list of the nonalphanumeric characters allowed in the prefix string specified by pdb_xlog_prefix. This list of allowed characters is database-specific. For example, in Microsoft SQL Server, the only nonalphanumeric characters allowed in a database object name are the $, #, @, and _ characters.
Use the pdb_xlog command to view the names of Replication Agent transaction log components in the primary database.
See the Replication Agent Administration Guide for details on setting up log object names.
Insert and delete permissions are granted to Public only on the DDL shadow table for the database name prefixddl_trig_xxx. No permissions are granted on other tables. Table objects that are considered Replication Agent objects are listed in the Replication Agent Primary Database Guide.
Procedure objects that are considered Replication Agent objects are listed in the Replication Agent Primary Database Guide. The sp_SybSetLogforReplTable and sp_SybSetLogforReplProc procedures are created in the Microsoft SQL Server mssqlsystemresource system database. Although execute permission on these procedures is granted to Public, only the Replication Agent pds_username user can successfully execute the procedures, because only the pds_username user is granted select permission on the sys.sysschobjs table. No permissions are granted on the other procedures when they are created.
The marker procedures and marker shadow tables that are considered Replication Agent objects are listed in the Replication Agent Primary Database Guide. No permissions are granted when these procedures and tables are created.
The commands that are considered Replication Agent trigger objects are listed in the Replication Agent Primary Database Guide.
