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 Cloud Control 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