Best way to secure underlying tables in a view

2003-03-17 Thread Rick_Cale
Hi All, I have a view made of 4 tables with different owners. I want to grant users select privs on that view but I do not want them to select on underlying tables. What is best approach? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL

Re: Best way to secure underlying tables in a view

2003-03-17 Thread Jared . Still
PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Best way to secure underlying tables in a view Hi All, I have a view made of 4 tables with different owners. I want to grant users select privs