OraFAQ Forum: SQL & PL/SQL » Reference for values in SYS.AUD$.STATEMENTID

Home » SQL & PL/SQL » SQL & PL/SQL » Reference for values in SYS.AUD$.STATEMENTID (11.2.0.1)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Reference for values in SYS.AUD$.STATEMENTID [message #624400]

Mon, 22 September 2014 10:10

youngryand
Messages: 10
Registered: March 2014
Location: Madison, WI

Junior Member

I would like to find a reference that decodes the numeric values found in SYS.AUD$.STATMENTID. Specifically I'm interested in #22. I can't seem to find such a reference in the data dictionary, general search engines, or in MOS.

Please do not reply with other solutions, such as "use SYS.AUD$.PRIV_USED." I am only interested in this exact information at the moment.

Thank you very much,
Ryan

[Updated on: Mon, 22 September 2014 10:11]

Report message to a moderator

Re: Reference for values in SYS.AUD$.STATEMENTID [message #624403 is a reply to message #624400]

Mon, 22 September 2014 10:19

John Watson
Messages: 8976
Registered: January 2010
Location: Global Village

Senior Member

There is no column sys.aud$.statmentid. Do you mean dba_audit_trail.statementid ? If so, that is described in the docs.

Report message to a moderator

Re: Reference for values in SYS.AUD$.STATEMENTID [message #624405 is a reply to message #624400]

Mon, 22 September 2014 10:22

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I would like to find a reference that decodes the numeric values found in SYS.AUD$.STATMENTID.
does not seem to exist for me

Code: [Select all] [Show/ hide]

[oracle@localhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Mon Sep 22 08:20:18 2014

Copyright (c) 1982, 2010, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> desc aud$
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SESSIONID                                 NOT NULL NUMBER
 ENTRYID                                   NOT NULL NUMBER
 STATEMENT                                 NOT NULL NUMBER
 TIMESTAMP#                                         DATE
 USERID                                             VARCHAR2(30)
 USERHOST                                           VARCHAR2(128)
 TERMINAL                                           VARCHAR2(255)
 ACTION#                                   NOT NULL NUMBER
 RETURNCODE                                NOT NULL NUMBER
 OBJ$CREATOR                                        VARCHAR2(30)
 OBJ$NAME                                           VARCHAR2(128)
 AUTH$PRIVILEGES                                    VARCHAR2(16)
 AUTH$GRANTEE                                       VARCHAR2(30)
 NEW$OWNER                                          VARCHAR2(30)
 NEW$NAME                                           VARCHAR2(128)
 SES$ACTIONS                                        VARCHAR2(19)
 SES$TID                                            NUMBER
 LOGOFF$LREAD                                       NUMBER
 LOGOFF$PREAD                                       NUMBER
 LOGOFF$LWRITE                                      NUMBER
 LOGOFF$DEAD                                        NUMBER
 LOGOFF$TIME                                        DATE
 COMMENT$TEXT                                       VARCHAR2(4000)
 CLIENTID                                           VARCHAR2(64)
 SPARE1                                             VARCHAR2(255)
 SPARE2                                             NUMBER
 OBJ$LABEL                                          RAW(255)
 SES$LABEL                                          RAW(255)
 PRIV$USED                                          NUMBER
 SESSIONCPU                                         NUMBER
 NTIMESTAMP#                                        TIMESTAMP(6)
 PROXY$SID                                          NUMBER
 USER$GUID                                          VARCHAR2(32)
 INSTANCE#                                          NUMBER
 PROCESS#                                           VARCHAR2(16)
 XID                                                RAW(8)
 AUDITID                                            VARCHAR2(64)
 SCN                                                NUMBER
 DBID                                               NUMBER
 SQLBIND                                            CLOB
 SQLTEXT                                            CLOB
 OBJ$EDITION                                        VARCHAR2(30)

SQL>

Report message to a moderator

Re: Reference for values in SYS.AUD$.STATEMENTID [message #624406 is a reply to message #624403]

Mon, 22 September 2014 10:25

youngryand
Messages: 10
Registered: March 2014
Location: Madison, WI

Junior Member

Thank you John. Yes, you are right, and that is the root of my inability to find documentation. Please disregard my question. I was lead to believe this column meant something other than what it apparently does based on the documentation I can now very easily find.

Report message to a moderator

Re: Reference for values in SYS.AUD$.STATEMENTID [message #624416 is a reply to message #624406]

Mon, 22 September 2014 10:42

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

Apart from what John mentioned, I see the STATEMENTID column in DBA_COMMON_AUDIT_TRAIL and DBA_AUDIT_OBJECT.

Report message to a moderator

Previous Topic:	Multiple Records in single xml with compound trigger
Next Topic:	mutating trigger

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 28 14:58:07 CDT 2025