Friday, July 10, 2009

ORA-26723: user "STRMADMIN" requires the role "DBA"

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"