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 definition.
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,
R.