Lets say,

user A queries

select * from scott.emp;


user B queries

select * from scott.emp;

But user B does not have previlages on scott.emp table.

Since both the statements are identically same, does oracle parses the statement again
or does it gets the info about the previleges from existing execution plan in the library cach to return the error?

Regards
sonia