Dba_audit_trail Return Code 1017
Related View USER_AUDIT_TRAIL displays all audit trail entries related to the current user. I am hoping to write a script to select specific rows from DBA_AUDIT_TRAIL and return information about those rows. Thanks in advance for any help you can provide. You may have to register before you can post: click the register link above to proceed. this contact form
Fill in your details below or click an icon to log in: Email (required) (Address never made public) Name (required) Website You are commenting using your WordPress.com account. (LogOut/Change) You are It also records if the action failed, for example, failure due to a security violation. The time now is 23:48. Generated Wed, 28 Dec 2016 05:48:41 GMT by s_wx1077 (squid/3.5.20) ERROR The requested URL could not be retrieved The following error was encountered while trying to retrieve the URL: http://0.0.0.10/ Connection https://docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_3056.htm
Dba_audit_trail Return Code 1017
For instance a value of 2004 refers to ORA-2004 "security violation". Column Datatype NULL Description OS_USERNAME VARCHAR2(255) Operating system login username of the user whose actions were audited USERNAME VARCHAR2(30) Name (not ID number) of the user whose actions were Answer: The dba_audit_trail is a view based on the aud$ table which decodes most of the values inside the table to present it in a user understandable manner. I was asking if anyone knows if this information lives anywhere in the database.
Similarly, the column action# column holds the user's action in a numeral form. Verify experience! For instance, the column spare1 in aud$ actually stores the Operating System User Name. Dba_audit_trail Action Code prakashs43 did read my question correctly!
The question is not about command resturn codes. I would like to obtain the description of the returncode error code from somewhere inside the database. Notify me of new posts via email. Forum FAQ Calendar Forum Actions Mark Forums Read Quick Links View Site Leaders Who's Online What's New?
Forum New Posts Today's Posts FAQ Calendar Forum Actions Mark Forums Read Quick Links View Site Leaders dBforums Database Server Software Oracle DBA_AUDIT_TRAIL Returncode column If this is your first visit, Oracle Audit Action Codes List [email protected] Fri Aug 10, 11:36:00 AM Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) Labels 188.8.131.52.0 (1) Advance Replication (2) ARCHIVE LOG backup/recovery Many Options (4) Experience comes from bad judgement. dba_audit_exists: This is an audit trail of the entries where the operation failed due to non-existing objects.
Dba_audit_trail Return Code Values
It was my misunderstanding that was the block. http://www.dbasupport.com/forums/showthread.php?31126-AUDIT-returncode-lookup Some useful values: 0 - Action succeeded 2004 - Security violation PRIV_USED VARCHAR2(40) System privilege used to execute the action CLIENT_ID VARCHAR2(64) Client identifier in each Oracle session ECONTEXT_ID Dba_audit_trail Return Code 1017 Just e-mail: and include the URL for the page. Oracle Audit Return Code List a user selected from a table, or altered another table, etc.
Powered by vBulletinCopyright ©2000 - 2016, Jelsoft Enterprises Ltd.Forum Answers by - Gio~Logist - Vbulletin Solutions & Services Home Register New Posts Advertising Archive Privacy Statement Sitemap Top Hosting and Cloud weblink SQL> truncate table aud$;Table truncated.1.audit table by access;BOTH successful or not successful statement2.audit table by access whenever successful;SUCCESSFUL statement only3.audit table by access whenever not successful;NOT SUCCESSFUL statement only4.audit table by To start viewing messages, select the forum that you want to visit from the selection below. Errata? Dba_audit_trail Return Code List
Please try the request again. You can get personalized Oracle training by Donald Burleson, right at your shop! Burleson is the American Team Note: This Oracle documentation was Thanks! navigate here dba_audit_object: Finally, this view shows all the audit records that were based on database object accesses: e.g.
ACTION_NAME VARCHAR2(28) Name of the action type corresponding to the numeric code in the ACTION column NEW_OWNER VARCHAR2(30) Owner of the object named in the NEW_NAME column NEW_NAME VARCHAR2(128) Dba_audit_trail 11g Advertisement dBforums Brief Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors Top Helpers healdem - 59 mark.b - 55 Pat Phelan - 54 ranman256 - 24 Burleson Consulting The Oracle of Database Support Oracle Performance Tuning Remote DBA Services Copyright © 1996 - 2016 All rights reserved by Burleson Oracle is the registered trademark of
All legitimate Oracle experts publish their Oracle qualifications.
Also see this books on Oracle auditing: Oracle Forensics: Oracle Security Best Practices Oracle Training from Don Burleson The best on site "Oracle training classes" are just a phone Positions 14, 15, and 16 are reserved for future use. This: SELECT SYSDATE TODAY FROM DUAL; Is easier to execute in a test case script than this: SQL> SELECT 2 SYSDATE TODAY 3 FROM 4 DUAL; ******************** Greater than and Less Dba_audit_trail Action_name Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson Blogdba_audit_trail tips Oracle Database Tips by Burleson Consulting March
If the command was successful, then the value of returncode will be 0 siva prakash DBA Reply With Quote 11-08-2002,11:26 AM #3 gopi View Profile View Forum Posts Tree Hugger Join My questions is, does anyone know if there is a table in the database that contains the complete list of ORA-99999 error codes and their descriptions? Please replace these characters in the code sections with the HTML equivalents for these characters: < < > > Blog at WordPress.com. %d bloggers like this: Database Journal | SQLCourse | http://technologyprometheus.com/return-code/vsam-catalog-return-code-is-8-reason-code-is-igg0cleg-42.html Your cache administrator is webmaster.
SQL Uncategorized VBS Recent Articles Huge Presentation - Working with Oracle Database in C#, VBScript, and Excel; Enhancing Visual Manufacturing8.0.0 Programming for Style and Beautiful Black Boxes - is Fast Performance Reply With Quote 04-30-08,12:25 #2 anacedent View Profile View Forum Posts Registered User Join Date Aug 2003 Location Where the Surf Meets the Turf @Del Mar, CA Posts 7,776 Provided Answers: Go to main content 534/1627 DBA_AUDIT_TRAIL DBA_AUDIT_TRAIL displays all audit trail entries. I am writing a script to troll through the audit table and list specific audit records.
The error is related to the overall ORA errors.