Hi
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?
I think that oracle would not reparse the statement, but always check the security. Because the securtiy can always change.

The Explan-plan does not conatain security-information.
The dictionary does.

Orca




[Edited by Orca777 on 07-12-2002 at 03:38 AM]