SQL Parsing

[Sonia]

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

[Sonia]

?????

[pando]

plz dont abuse

[Horace]

Pando,

what do you mean by 'plz don't abuse' ?

[shailendra]

Well it will not parse the statement again.

[Sonia]

hi,
then the user B has no preivilege on the table. But he has issued the same query., at what stage does it verifies that....

[Orca777]

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]

[pando]

Originally posted by Horace
Pando,

what do you mean by 'plz don't abuse' ?

I mean you dont have to spam to get an answer, if we know we will help you. Noone is forced to answer a question here

[Orca777]

Hi pando;
Sometimes it's good to not give up!
I am a character often not asks, but
who will not continue in asking ( hopefully the right questions )
will not get the answer, the gift.

Orca

[pando]

Well noone here is blind or cant read isnt it?
It´s not about giving up asking, we read, if we can answer we do