Replication USER & EXECUTE permissions.

From: <dmkelsey_at_my-dejanews.com>
Date: Fri, 07 May 1999 18:51:51 GMT
Message-ID: <7gvco4$o40$1@nnrp1.deja.com>

I'm using:

Orcle Lite 3.5
Oracle 8.0.5.0.0 Enterprise (NT)

I've written a VB app that uses the RepSvr8.OCX control to perform Replication. On the master site I've created a simple table:

  CREATE TABLE foo
  (
    foo_id VARCHAR2(5) NOT NULL,
    foo_value VARCHAR2(5)
  )

and put some values into it. The owner schema is 'DAVE'.

In the VB app I create an updatable-snapshot from the table 'FOO' and add it to a refresh group. Exact steps are:

'======================================================================
' Reset the snapshot Refresh Group.
'======================================================================

Call RepSvr.SnapshotGroupReset

'======================================================================
' Adding snapshots to the Snapshot Refresh Group.
'======================================================================

    Const FAST_REFRESH = 0
    Const COMPLETE_REFRESH = 1
    Const OPTIMUM_REFRESH = 2

Call RepSvr.SnapshotGroupAdd(m_ownerStore, m_nameStore, FAST_REFRESH)

'======================================================================
' Refresh the Snapshot Refresh Group.
'======================================================================

hr = RepSvr.SnapshotGroupRefresh(True)

When this last line executes the animated dialog indicating that replication is ocuring executes for a couple of seconds. Then I get a number of 'package not found' type errors. These include 'SYS.DBMS_DEFER_INTERNAL_SYS',
'SYS.DBMS_DEFER', and something called 'FOO$RP.rep_insert()'. I connect as
'SYS' and GRANT EXECUTE ON both ...INTERNAT_SYS and ...DEFER. There is
obviously something wrong with the 'DAVE' user--Some sort of configuration script needs to be executed on that user. I haven't found anything that specifically states 'run BLAH.sql to configure the Replication user account'.

Any suggestions would be greatly appreciated.

Dave
cst96031_at_camosun.bc.ca

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri May 07 1999 - 13:51:51 CDT