SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Is it possible to view "all_tab_columns" entries in "user_tab_columns"?

scampsdAug 11 2011 — edited Aug 11 2011

Good morning,
I have here a SQL query that searches for entries in "user_tab_columns".
Unfortunately the mentioned entries are not present there (but they are present in "all_tab_columns", but I also think that the query is correct.

Therefore I wonder:
is it possible to modify the database (using granting permissions, DB links or other) so that the mentioned entries in "all_tab_columns" also get visible in "user_tab_columns"?

Thanks
Dominique

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 8 2011

Added on Aug 11 2011

7 comments

1,680 views