How can I create a trigger on select

[huchen]

Hello,

I want to check if a table(table_a) will be used in next 2 months and who is using it.

Here is what I want to do:

create a trigger on select on table_a
insert into table_log(sysdate, user,sql_text);

But trigger can not be created on select, How can I achieve this?

Thank you

 

[huchen]

All I need is to find out if this table is used at all.

 

[huchen]

Never mind, dbms_fga.add_policy works for me.