PeopleSoft Audit

今天药忘吃喽~ 2021-11-13 18:34 274阅读 0赞

Same way as a delivered record (or you can add audits to a delivered record if it doesn't already have them). You can either turn audit on for individual fields or build a custom audit record.  
  
To audit field changes, double-click on the record field and choose the actions that should trigger an audit record to be written. Results are in PSAUDIT for that record name with one row per field audited. The rows are identified by the name of the record being audited and the complete key structure for that record corresponding to the row that was modified.  
  
To create an audit record, do a save as on your custom record to another record name with AUDIT\_ as a prefix. Don't copy PeopleCode. Insert AUDIT\_OPRID, AUDIT\_STAMP, and AUDIT\_ACTN as the first three fields. Remove any fields you don't care about. Save the record and build it on the database. Then go back to the original custom record, open its properties, click to the Use tab, and assign your new AUDIT\_ record as the audit record.  
  
I would add to this that you should also update the audit delete SQR so your audit record's contents are periodically purged. If you don't clear the audit  
record the potential for performance impacts will begin to show.

转载于:https://www.cnblogs.com/GoDevil/archive/2009/02/12/1388812.html

发表评论取消回复

表情：

评论列表（有 0 条评论，274人围观）

还没有评论，来说两句吧...

相关阅读

相关 7 Steps to Setup A Record Level Audit in PeopleSoft

Record level Auditing As the name suggests, record level auditing is the auditin...

小灰灰/ 2024年04月17日 05:22/ 0 赞/ 67 阅读

相关 ORACLE AUDIT命令

AUDIT Purpose Use the `AUDIT` statement to: Track the occurrence of SQL statemen

刺骨的言语ヽ痛彻心扉/ 2023年10月19日 07:56/ 0 赞/ 121 阅读

相关 linux审计工具audit,Linux audit 审计工具

centos 系统 audit 默认是安装的查看状态： \[root@ecs-proxy ~\]\ service auditd status \[root@ecs-p

拼搏现实的明天。/ 2023年01月20日 12:48/ 0 赞/ 210 阅读

相关 peoplesoft链接oracle,Oracle OAM实现PeopleSoft SSO单点登录

/\----peoplesoft sso-----\/ Function Oracle\_Access\_Manager\_Authentication() /\ Note

怼烎@/ 2023年01月18日 06:37/ 0 赞/ 153 阅读

相关 Writing Audit Plugins

本文转载自： http://docs.oracle.com/cd/E17952\_01/refman-5.5-en/writing-audit-plugins.ht

你的名字/ 2022年09月20日 15:17/ 0 赞/ 153 阅读

相关 HengWang/mysql-audit

本文转载自：https://github.com/HengWang/mysql-audit [HengWang][]/[mysql-audit][] !

今天药忘吃喽~/ 2022年08月23日 11:55/ 0 赞/ 144 阅读

相关 PeopleSoft技术（PeopleCode学习1）

本片文章主要讲一些PeopleCode的基础知识，后面会有PeopleCode练习的篇章一、PeopleCode概述当业务数据自身的约束不能满足业务需求时，使

朱雀/ 2022年05月27日 10:50/ 0 赞/ 255 阅读

相关 JPA Audit 说明

作用 @CreatedDate 表示该字段为创建时间时间字段，在这个实体被insert的时候，会设置值 @CreatedBy 表示该字段为创建人，在这个实体被i

清疚/ 2022年01月11日 08:09/ 0 赞/ 226 阅读

相关 Debugging Functionality in Peoplesoft

Open Configuration Manager -> Profile ->Create. • Select Connection Type as Applicatio

川长思鸟来/ 2021年12月15日 02:53/ 0 赞/ 212 阅读

相关 PeopleSoft Audit

Same way as a delivered record (or you can add audits to a delivered record if it doesn'

今天药忘吃喽~/ 2021年11月13日 18:34/ 0 赞/ 275 阅读