A.2.4 User Requiring Access to SQL Access Advisor

1. 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>;
   

2. 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.

3. To perform SQL Access tasks, complete steps in the wizard