I have a user called sam. I want the user to be able to use OEM tosee all the objects in the database (with no select priveledges). Sam is able to connect through OEM to see all the objects onlywhen I grant "select on any/table_name to sam".

I want to take the select priveledges away from SAM, so that he would not be able to select from any table. If I take the select privelledge away from SAM, he would not be able to connect to OEM anymore. So in this case after taking away the select privelledge, what permission do I need to grant SAM to be able to use the OEM?

BELOW IS WHAT I DID WHEN I GRANTED SAM THE SELECT PRIVELEDGES:

create user sam identified by sampson
default tablespace data_tablespace
temporary tablespace temp;

grant connect, create session to sam;
grant oem_monitor to sam;
grant select_catalog_role to sam;
grant select any table to sam;