Permissions all_tab_columns
510367May 2 2006 — edited May 4 2006Hello to everybody,
I've got a small problem. I have got a function which compairs the tables and colums of two schemas of the same data base. this function is defined in one of the two schemas.
The function has two querys : select count(*) from all_tab_columns where owner='A' etc...
and select coun(*) from all_tab_columns where owner='B' etc...
when I am in schema A (in which the function is defined) and I execute the function it gives me 0 in the select(the one with owner B) (when the result is 1) , If instead of executing the function I cut and paste only the query, it gives me 1!!!! I was thinking it was a problem of granting permissions to the function... does anybody knows why??? if I execute the query (the one with owner='B') from eschema A it gives me the good result: 1. If I execute the function from the schema A it gives me 0 (bad result)