Hide View Definitions

Hi,
I am facing a bit of a problem:
I have User A, which owns a table (T1) and a view on the table (V1). I have User B, which has select privilege on A.V1 view. If user B queries the ALL_VIEWS view, he can see the view definion. I don't want user B to see the view text. I tried creating a second view (V2) in User A's schema, that performs a SELECT from V1, but the user can still see the query text in ALL_VIEWS view.

How can i hide the view text from user B?

Thanks,
THC. Received on Wed Nov 27 2002 - 03:12:58 CST