HI guys,
Am trying to do the above. Managed to configured the distributer. However, while trying to configure my oracle publisher, it failed as follows:
====================================================
Creating Publication
- Creating Publication 'oraTest' (Success)
* SQL Server created publication 'oraTest'.
- Adding article 1 of 1 (Error)
Messages
* SQL Server Management Studio could not create article 'USERS'. (New Publication Wizard)
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
Objects cannot be published from the publisher login schema [SCOTT].
Changed database context to 'distribution'. (Microsoft SQL Server, Error: 20802)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1187&EvtSrc=MSSQLServer&EvtID=20802&LinkId=20476
======================================================
As u guys can see, the publisher was created smoothly. It is the adding of the article, ie. my oracle table. I have ran the permission script as instructed in the BOL.
Wat am I missing? Can anyone pls help?
Thanks!
Cheers,
Kevin
-
Can you please make sure that you have granted read permissions on the tables to the Oracle user account for managing Oracle publisher?|||Kevin -
The reason that you get this message is that you tried to publish tables that were in the schema account that you provided for replication. This is not supported since the replication account in Oracle is used strictly for supporting replication. As Mahesh mentions above, you just need to grant select on your tables (which shouldn't be owned by the replication user) to the replication user you created.
Matt Hollingsworth
Program Manager
No comments:
Post a Comment