USER_TABLES

From: Brian Everett <brian.everett01_at_removeherecomcast.net>
Date: Sun, 03 Nov 2002 12:18:25 -0500
Message-ID: <49masukg77mkht9pjceq5t41mq6klvcuji@4ax.com>

In a procedure I need to have a list of tables from another schema. Can I be given rights to view someone else's USER views?

If I am in Bob schema and I want to see a list of tables owned by Fred in his schema could
I look at SELECT TABLE_NAMES FROM FRED.USER_TABLES with the correct grant ?

Currently, if I am Bob I can do a DESC FRED.USER_TABLES and get a proper return.

Note: I need this question answered. I don't require an alternative.

Thanks,

Brian Received on Sun Nov 03 2002 - 11:18:25 CST