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!

USER_TAB_COLUMNS and ALL_TAB_COLUMNS

420246Jan 24 2005 — edited Jan 24 2005

Dear Experts,

I'm logged on a schema called Product with a user having the following rights:
- Create Session
- Select any sequence
- Select any table

If I perform a select on USER_TAB_COLUMNS I don't get any row returned but I do get results if I perform a select on ALL_TAB_COLUMNS. I can these two tables are SYS and select is granted to PUBLIC on both.

So I don't undestand why I don't get a result from USER_TAB_COLUMNS. Any clue ?

Thanks for any help.
BR,
Jerome.

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 21 2005

Added on Jan 24 2005

1 comment

378 views