connormcd / audit_utility

Automatic generator for the typical audit triggers we have on Oracle tables with lots of options
51 stars 20 forks source link

Please add filter on schemas only in schema_list to audit_util.dup_cnt #12

Closed akluev closed 1 year ago

akluev commented 1 year ago
function dup_cnt(p_table_name varchar2, p_owner varchar2) return number is
  l_dup_cnt int;
begin
  select count(*)
  into   l_dup_cnt
  from   dba_tables
  where  table_name = upper(p_table_name)
  and    owner != g_aud_schema
  and owner in ( select schema_name from aud_util.schema_list)