Hi,
may be an easy question, but have not managed to find an answer yet.
I have a table MYTABLE and I have a view MYVIEW.
MYVIEW is set up as:
create or replace force view MYVIEW
as select * from MYTABLE
Is it possible to restrict direct access to MYTABLE so that users cannot run a select * from MYTABLE, but they can view the results only if they run select * from MYVIEW?
Thanks very mucyh in advance