Skip to Main Content

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_tables and user_views?

User_MNFGRDec 26 2019 — edited Dec 27 2019

Hello oracle team,

as I still quite new with oracle, and I'm got some request from user that they want to

select * from user_tables or user_views while connected on user A,

and will list down all user B's tables and views.

Any idea please help.

Comments
Post Details
Added on Dec 26 2019
2 comments
720 views