When running DBMS_STREAMS_ADM.ADD_TABLE_RULES on a database with Database Vault enabled you get :-
ERROR at line 1:
ORA-26723: user "STRMADMIN" requires the role "DBA"
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 372
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 312
ORA-06512: at line 2
STRMADMIN has the DBA role, so the error message is wrong.
Cause :- Database Vault revokes become user, which causes Datapump and Streams to fail.
Solution :- "grant become user to strmadmin"
Subscribe to:
Post Comments (Atom)
2 comments:
O thank's a lott, that helps!
Thanks very much.
without your help I'll suffer all day long..^^;
Post a Comment