Database Administration (MOSC)

MOSC Banner

The current user <username> has not been granted the ADVISOR privilege despite having it !

edited Aug 18, 2017 5:03AM in Database Administration (MOSC) 3 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center