Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> replication manager failing

replication manager failing

From: STEVE <spectre_at_hkstar.com>
Date: Thu, 22 Jul 1999 12:32:15 +0800
Message-ID: <1dvcg05.1fd34gnrb6bouN@[201.1.1.74]>


Hi,
I have the following problem with the replication manager wizzard. on netware 4.11 oracle 8

I cannot get it to assign the correct rights to "repadmin", which I thought was the default.
Here is the script whicvh i saved.

/*-- Connection to: SYSTEM_at_ORACLE.WORLD --*/

/*---

Creating user 'REPADMIN' at site 'TCP_MICRO02_CN'

---*/

create user REPADMIN identified by REPADMIN

/*---

Granting admin privileges to user 'REPADMIN' at site 'TCP_MICRO02_CN'

---*/

begin

       dbms_repcat_admin.grant_admin_any_schema(

       username => 'REPADMIN');

end;

/******** Error:

ORA-06550: line 2, column 2:

PLS-00201: identifier 'DBMS_REPCAT_ADMIN.GRANT_ADMIN_ANY_SCHEMA' must be declared

ORA-06550: line 2, column 2:

PL/SQL: Statement ignored

********/

/*---

Registering user 'REPADMIN' as propagator at site 'TCP_MICRO02_CN'

---*/

begin

   dbms_defer_sys.register_propagator(username => 'REPADMIN');

end;

/******** Error:

ORA-06550: line 2, column 4:

PLS-00201: identifier 'DBMS_DEFER_SYS.REGISTER_PROPAGATOR' must be declared

ORA-06550: line 2, column 4:

PL/SQL: Statement ignored

********/

/*---

Granting privileges to user 'REPADMIN'

---*/

grant execute any procedure to REPADMIN

/*---

Granting privileges to user 'ORACLE'

---*/

grant alter session to ORACLE

/*---

Granting privileges to user 'ORACLE'

---*/

grant create cluster to ORACLE

/*---

Granting privileges to user 'ORACLE'

---*/

grant create database link to ORACLE

/*---

Granting privileges to user 'ORACLE'

---*/

grant create sequence to ORACLE

/*---

Granting privileges to user 'ORACLE'

---*/

grant create session to ORACLE

/*---

Granting privileges to user 'ORACLE'

---*/

grant create synonym to ORACLE

/*---

Granting privileges to user 'ORACLE'

---*/

grant create table to ORACLE

/*---

Granting privileges to user 'ORACLE'

---*/

grant create view to ORACLE

/*---

Granting privileges to user 'ORACLE'

---*/

grant create procedure to ORACLE

/*---

Granting privileges to user 'ORACLE'

---*/

grant create trigger to ORACLE

/*---

Granting privileges to user 'ORACLE'

---*/

grant unlimited tablespace to ORACLE

/*---

Granting privileges to user 'ORACLE'

---*/

grant create type to ORACLE

/*---

Granting privileges to user 'ORACLE'

---*/

grant create any snapshot to ORACLE

/*---

Granting privileges to user 'ORACLE'

---*/

grant alter any snapshot to ORACLE Received on Wed Jul 21 1999 - 23:32:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US