Hide view definitions
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
How can i hide the view text from user B?
It is better to ask and appear ignorant, than to remain silent and remain ignorant.
Oracle OCP DBA 9i,
C++, Java developer
Click Here to Expand Forum to Full Width