The current user <username> has not been granted the ADVISOR privilege despite having it !
Hi,
I'm trying to follow ML note 2499931.1 'Using Dbms_Advisor.Tune_Mview To Optimize Materialized Views For Fast Refresh' and am receiving an error suggesting the user4 does Not have the Advisor privilege
despite the fact that it does. What am I missing ?
Every note I've found so far suggests granting the privilege is the fix.
I have and still getting the error.
Version 11.2.0.3 on Redhat 5
select * from dba_sys_privs where grantee = 'SOAUSER';
GRANTEE PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
SOAUSER CREATE MATERIALIZED VIEW NO
SOAUSER CREATE VIEW NO
SOAUSER CREATE PUBLIC SYNONYM NO
SOAUSER SELECT ANY DICTIONARY NO
SOAUSER ON COMMIT REFRESH NO