Home » Developer & Programmer » Forms » i want (((audit.fmb FORMS )))
i want (((audit.fmb FORMS ))) [message #352033] Sun, 05 October 2008 07:55 Go to next message
mohanad079
Messages: 6
Registered: October 2008
Location: JORDAN
Junior Member
hi ...
please everybody : if there anyone can upload to me audit form
with code or without ( Fmb or Fmx ) ;

anyone can help me plz???!

Edited by LF: fixed both title and message body; the original title had "aduit.fmp"; both misspelled words were modified to "audit" and "FMB"

[Updated on: Mon, 06 October 2008 00:28] by Moderator

Report message to a moderator

Re: i want (((aduit.fmp FORMS ))) [message #352037 is a reply to message #352033] Sun, 05 October 2008 08:58 Go to previous messageGo to next message
Littlefoot
Messages: 20896
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I must admit that I have no idea what "aduit" and "fmp" are.
icon9.gif  Re: i want (((aduit.fmp FORMS ))) [message #352046 is a reply to message #352037] Sun, 05 October 2008 11:14 Go to previous messageGo to next message
mohanad079
Messages: 6
Registered: October 2008
Location: JORDAN
Junior Member
Sorry ; spelling of what i write is error ..
i mean Audit ( know who is delete,update ... data )
i want a form that do this ...

i want (.fmb) file

Re: i want (((aduit.fmp FORMS ))) [message #352079 is a reply to message #352046] Mon, 06 October 2008 00:26 Go to previous messageGo to next message
Littlefoot
Messages: 20896
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You want to enable auditing via forms? Why? What's wrong with the way Oracle suggests in the Security Guide?

Oh, yes - I don't have such a form so - as far as I'm concerned - you're out of luck.

Now I'll fix spelling mistakes you have made in the topic title. However, perhaps you'd want to correct your location (in your profile). I suppose it is Jordan, not Joradn.
Re: i want (((aduit.fmp FORMS ))) [message #352085 is a reply to message #352079] Mon, 06 October 2008 01:04 Go to previous messageGo to next message
mohanad079
Messages: 6
Registered: October 2008
Location: JORDAN
Junior Member
yes ;; thanks:) i want form; its so easy to know who add,delete,update ,,,

[Updated on: Mon, 06 October 2008 01:07]

Report message to a moderator

Re: i want (((audit.fmb FORMS ))) [message #352115 is a reply to message #352033] Mon, 06 October 2008 04:00 Go to previous messageGo to next message
islam175
Messages: 10
Registered: March 2008
Location: Jordan
Junior Member
dear Mr.Mohanad
first you have to create table as a trace(auditting table) table ( contain like a username, date , action columns ) then you can simply make the form which you want
hope good luck for you
Re: i want (((audit.fmb FORMS ))) [message #352121 is a reply to message #352115] Mon, 06 October 2008 04:17 Go to previous messageGo to next message
mohanad079
Messages: 6
Registered: October 2008
Location: JORDAN
Junior Member
thanks for reply ;; i want to say something ; i use this ( i create in every table 2 column (( Update_user,Insert_User)) and i add triger on these column ( before insert .. update ...))

i see this way is not good ;; it take Time (when add table then add these columns and triger ... )

so what other way if anyone know!?! i want a Form Doing this;;;

thanks all ;;;

[Updated on: Mon, 06 October 2008 04:21]

Report message to a moderator

Re: i want (((audit.fmb FORMS ))) [message #352151 is a reply to message #352121] Mon, 06 October 2008 05:54 Go to previous messageGo to next message
Littlefoot
Messages: 20896
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Well, obviously you haven't checked the link I posted earlier.

Basically, you have two options:
  1. use auditing provided by Oracle
  2. use your own auditing. This one is fine as well, but only if you want to do the job (yes, it means you'll have to create a table, write triggers etc.).
However, as you are reluctant to option 1) and don't want to code the option 2), it seems that you'd better give up auditing completely.

Re: i want (((audit.fmb FORMS ))) [message #352162 is a reply to message #352151] Mon, 06 October 2008 07:12 Go to previous message
mohanad079
Messages: 6
Registered: October 2008
Location: JORDAN
Junior Member
yes man ; i see your link ;; its very good ; but it seem very complex !

anyway ; if you can send me form of audit ; this what i want!
ok ; as i have not time to read time to read what you post :

can you told me the name of table and column in database that give you who is create table , delete , insert , update ... date ! thanks again for your help ...

Smile
Previous Topic: I can't remove "Window" menu at Forms 6i
Next Topic: Convert repeating record to one record
Goto Forum:
  


Current Time: Tue Dec 06 06:30:49 CST 2016

Total time taken to generate the page: 0.12734 seconds