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 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.
It is better to ask and appear ignorant, than to remain silent and remain ignorant.
Oracle OCP DBA 9i,
C++, Java developer