OraFAQ Forum: Forms » i want (((audit.fmb FORMS )))

Home » Developer & Programmer » Forms » i want (((audit.fmb FORMS )))

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

i want (((audit.fmb FORMS ))) [message #352033]

Sun, 05 October 2008 07:55

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

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I must admit that I have no idea what "aduit" and "fmp" are.

Report message to a moderator

Re: i want (((aduit.fmp FORMS ))) [message #352046 is a reply to message #352037]

Sun, 05 October 2008 11:14

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

Report message to a moderator

Re: i want (((aduit.fmp FORMS ))) [message #352079 is a reply to message #352046]

Mon, 06 October 2008 00:26

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: i want (((aduit.fmp FORMS ))) [message #352085 is a reply to message #352079]

Mon, 06 October 2008 01:04

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

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

Report message to a moderator

Re: i want (((audit.fmb FORMS ))) [message #352121 is a reply to message #352115]

Mon, 06 October 2008 04:17

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

Littlefoot
Messages: 21823
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:

use auditing provided by Oracle
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.

Report message to a moderator

Re: i want (((audit.fmb FORMS ))) [message #352162 is a reply to message #352151]

Mon, 06 October 2008 07:12

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 12:23:49 CST 2025