Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 19th July 2002, 04:24
therese therese is offline
Member
 
Join Date: Sep 2001
Posts: 40
therese is on a distinguished road
Baan: Baan4c4,Baan4c3,Baan4b2 - DB: Oracle,Informix - OS: Unix
identify user who edit a field in baan session

Is there a way to identify a user who edit a certain field in baan session? Let say, we want to know who is responsible in changing item description in Item data.

PLease Help.
Reply With Quote
  #2  
Old 19th July 2002, 07:02
morpheus's Avatar
morpheus morpheus is offline
Guru
 
Join Date: Jun 2002
Location: Planet of the apes
Posts: 369
morpheus is on a distinguished road
Baan: BaaN IV c4 - DB: BaaN Base - OS: HP-UX 11
Audit

Hello,
Try putting audit on the tables. Also, you can maintain history of the user.
Reply With Quote
Sponsored Links
  #3  
Old 19th July 2002, 07:26
Francesco's Avatar
Francesco Francesco is offline
Guru
 
Join Date: Aug 2001
Location: Antwerp, BE
Posts: 727
Francesco is on a distinguished road
Baan: 5b - DB: Oracle - OS: Solaris
Hi Therese,

There is no way to monitor specific fields in Baan. As morpheus says, you can use the audit features to see who's 'messing' with your tables, or activate user history (both come with significant overhead), but in my experience the only way to prevent users from getting into areas they are not supposed to is by means of security.

Establish ownership of your items table and restrict access to the proper owners only. That way, if anything happens to the data, there is no other responsible party than the people who are supposed to maintain that data in the first place.
__________________
Cheers,

Francesco
..............................................................

Admiral Business Solutions | My World | Baan Board | IT Happens!

"If everyone is thinking alike, then somebody isn't thinking" -- George Patton
"It's easy to cry 'bug' when the truth is that you've got a complex system and sometimes it takes a while to get all the components to co-exist peacefully." -- Doug Vargas
Reply With Quote
  #4  
Old 19th July 2002, 07:45
morpheus's Avatar
morpheus morpheus is offline
Guru
 
Join Date: Jun 2002
Location: Planet of the apes
Posts: 369
morpheus is on a distinguished road
Baan: BaaN IV c4 - DB: BaaN Base - OS: HP-UX 11
Overheads

Hello Francesco,
I agree that Audit and History come with an overhead. But, there are times when more that one parties are responsible for the data maintained in the system (including master tables). So, in such scenarios audit can be put on for important data. Also, the files generated in the process can be purged after regular intervals.
Reply With Quote
  #5  
Old 19th July 2002, 16:11
Smiffy's Avatar
Smiffy Smiffy is offline
Member
 
Join Date: Oct 2001
Location: UK
Posts: 64
Smiffy is on a distinguished road
Baan: Baan IV - DB: Baan - Oracle - OS: UNIX
there is a way

There is of course a way to achieve what you require, if you have development access to the code of the session. You can take a value of a field after a read (after.read) and before write (before.write). If there is a difference, the logged on users id could be stored on a table for a particular item (which links via the key field of the record).

This new table could store the id & date and time of the last person to change the field concerned. This may be a bit too much work if you want a quick and easy solution, but the possibility is there. You could make it more complex by storing the last 5 changes or something. I did something similar with a text field, keeping history of Purchase Order amendments, but that really was complex.

good luck
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
BSP-US (LLC) added as a Baan Education Alliance svandenh General Discussion & Chat 1 20th August 2001 19:44


All times are GMT +2. The time now is 09:33.


©2001-2017 - Baanboard.com - Baanforums.com