Publishing security data
The following section describes how to publish the security data associated with the main iBase database. Before you can configure the Publisher for a security database, the iBase administrator should have already set up the iBase security database on the server that is the Publisher.
Before you begin
If you intend to replicate the security audit log, include the _ AuditLog table when you create the publication.
- From the Object Explorer list, select
Publication., right-click and select
- Server: select the server that is also the Publisher of the entity and link data for the iBase system. (Use the same server for all publications.)
- On the Publication Database page, select the existing database
that contains the security data you want to publish. The database name is <database>_Sec where <database> is derived from the name of the ids file created at the publisher site.
- On the Publication Type page, select Merge publication.
- On the Subscriber Types page, ensure that only SQL Server 2008 or later is selected.
- On the Articles page, expand the Tables
node. Select these iBase system tables:
Note:You must not include these tables:
- _ AccessDenied
- _ AuditLog (omit this table if you do not want to replicate the security audit log)
- _AutoLogon (optional but only relevant if Windows Single Sign-On is used and users are able to log on to the different systems using the same Windows credentials)
- _SecurityPolicy (optional)
- _ UserGroup
- _ NextId
- Accept whatever article issues are reported - typically SQL Server warns that
“Uniqueidentifier columns will be added to tables”.
- Enter the publication name. For example, iBase_security_data.
- Generate the publication in the usual way. There are no additional properties to set for this type of publication.
What to do next
After you create the publication:
- Restrict access to the tables in the SQL Server database. See the Administration Center document Managing Access Control, for details.
- Back up
the database(s). See:
- The Administration Center document Creating and Maintaining Databases, for information on backing up iBase connection files
- Microsoft SQL Server documentation for information on backing up the replicated SQL Server databases
- Tell the iBase administrator that the security data at the Publisher is configured for replication.