Simple example
Create and enable a capture…
begin
dbms_privilege_capture.create_capture(
name => 'priv_capture_test',
description => 'Captures my_app_developer role use'
-- type => dbms_privilege_capture.g_role,
-- roles => role_name_list('…')
);
dbms_privilege_capture.enable_capture('priv_capture_test');
end;
/
Let some time pass nad users do their work…
Disable the capture and generate the result:
begin
dbms_privilege_capture.disable_capture('priv_capture_test');
dbms_privilege_capture.generate_result('priv_capture_test');
end;
/
Query the result:
select
upr.*
from
dba_used_privs upr
where
upr.capture ='priv_capture_test' and
upr.username = user;
Drop the capture:
begin
dbms_privilege_capture.drop_capture('priv_capture_test');
end;
/