title: Oracle database role - select from table across schemas without schema identifier
body: <p>Which Oracle database role will allow a user to select from a table in another schema without specifying the schema identifier? 
  i.e., as user A-  Grant select on A.table to user B;
  B can then- "Select * from table" without specifying the 'A'. 
  One of our databases allows this, the other returns a 'table or view does not exist' error. </p>