Printable View
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
?????
plz dont abuse
Pando,
what do you mean by 'plz don't abuse' ?
Well it will not parse the statement again.
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....
Hi
I think that oracle would not reparse the statement, but always check the security. Because the securtiy can always change.Quote:
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?
The Explan-plan does not conatain security-information.
The dictionary does.
Orca
[Edited by Orca777 on 07-12-2002 at 03:38 AM]
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 hereQuote:
Originally posted by Horace
Pando,
what do you mean by 'plz don't abuse' ?
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
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
YES Sir! ;-))
well,
just wanted to bring my question back to focus....
i meant nothing else...
coz the people who knew the answers would have been not online when i posted the question...so just brought it back to top...
and the good thing abt that it worked....atleast some of u could answer...
again it depends on ur attitude....there are people who always think positvely and there are some people who find mistakes in everything....
in the meantime what does the word abuse means....
spam