Hiding the VIEW script for a read only user
462893Oct 27 2005 — edited Oct 27 2005Hi ,
I have a view created, and wanted the ready only user to see just the data and not the script of the view.
When I grant select on the view, the user is able to see the script when user does a desc <view_name>. (from toad) Tried with a synonym also.
I had found an alternate way by creating view on top of the base view and restricting the script.
Please let me know if there is any way to achieve this other than the view-on-view .
Thanks in advance,
Pradeep.