Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> replication manager failing
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