DBMS_STREAMS_ADM.ADD_SCHEMA_RULES Fails with ORA-26723 in Oracle Database Vault Environment (Doc ID 1141093.1)

Last updated on SEPTEMBER 07, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.

Goal

DBMS_STREAMS_ADM.ADD_SCHEMA_RULES fails with ORA-26723

SQL> BEGIN
2 DBMS_STREAMS_ADM.ADD_SCHEMA_RULES(
3 schema_name => 'HR',
4 streams_type => 'CAPTURE',
5 streams_name => 'STREAM_CAPTURE',
6 queue_name => 'STRMADMIN.STREAMS_QUEUE',
7 include_dml => true,
8 include_ddl => true,
9 source_database => 'STRM1');
10 END;
11 /
*
ORA-26723: user "STRMADMIN" requirements role "DV_STREAMS_ADMIN"
ORA-06512: at "SYS.DBMS_STREAMS_ADM_UTL_INVOK", line 349
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 439
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 397
ORA-06512: at line 2

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms