User Requiring Access to SQL Access Advisor

On the DB Target host log in as sysdba and create a <sqlaccess_admin> user and grant the appropriate privileges:

SQL> create user <sqlaccess_admin> identified by <password>; 
SQL> grant select any dictionary to <sqlaccess_admin>; 
SQL> grant create session to <sqlaccess_admin>;
SQL> grant oem_advisor to <sqlaccess_admin>;

Log in to the Enterprise Manager console as <gc_user> user, which is JANEMURRY in our example:

TARGETS > DATABASE > ORADB > Related Links: Advisor Central >SQL Access Advisor Enter login and password for <sqlaccess_admin> user.
To perform SQL Access tasks, complete steps in the wizard