1

I found that auditing can be done on oracle schema objects like procedures and views. Is there any possibility to do the auditing on Types?

  • Is there any possibility to do the auditing on Types? what do you mean? what are the Types you want, can you name few?? – CR241 Dec 17 '18 at 18:39
  • I mean data types. – Anuradha Dec 18 '18 at 5:39
1

Types can be altered, granted/revoked privileges on, so why not?

Example:

SQL> select object_type from dba_objects where object_name = 'T1';

no rows selected

SQL> create type t1 is table of varchar2(20);
  2  /

Type created.

SQL> audit all on t1;

Audit succeeded.

SQL> select * from dba_obj_audit_opts where object_name = 'T1';

OWNER                OBJECT_NAME          OBJECT_TYPE             ALT       AUD       COM       DEL       GRA       IND       INS       LOC       REN       SEL       UPD       REF EXE       CRE       REA       WRI       FBK
-------------------- -------------------- ----------------------- --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- --- --------- --------- --------- --------- ---------
BP                   T1                   TYPE                    A/A       A/A       -/-       -/-       A/A       -/-       -/-       -/-       -/-       -/-       -/-       -/- A/A       A/A       -/-       -/-       -/-

See DBA_OBJ_AUDIT_OPTS and AUDIT for details.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.