Re: auditing access to object

Database event "Audit Schema Object Access Event", ObjectName column
with one row for each object in the view.
Hi,
I need to audit any access to table (example table creditcards)
profiler work fine if table creditcards referenced
by select/ upadate/delete or procedure



but if I create view

create v_alex
as
select * from creditcards

profiler with all events would show only v_alex

Application modifing and number of views growing ...



Any way to trace accees to creditcards if it referenced by view ?

.

Relevant Pages

  • Re: auditing access to object
    ... Database event "Audit Schema Object Access Event", ... I need to audit any access to table (example table creditcards) ... profiler work fine if table creditcards referenced ...
    (microsoft.public.sqlserver.security)
  • Re: auditing access to object
    ... Database event "Audit Schema Object Access Event", ... I need to audit any access to table (example table creditcards) ... profiler work fine if table creditcards referenced ...
    (microsoft.public.sqlserver.security)