Is there any simple report in Baan DEM which can print which user has access to what sessions ?

There are standard baan reports which are horrible (Print Activity Authorization by Employee tgbrg4450m000). They run for days and the output is horrible, difficult to understand and INCOMPLETE.

If not, then I will have to write my own SQL Server Queries to read verious DEM tables and generate a readable report, which will be easy to understand by a normal user.

Has anyone done any work like this on DEM's before?

Nothing standard that I am aware of - I think a consultant took the standard one and modified it for us. Also something to be aware of is that the DEM flow does not give the whole story. One session can add user permissions for 20 other sessions - which the DEM flow does not show. I am happy we no longer have to worry about SOX.

tgbrg8441m000 - Print DEM session Auth
Not sure if this is in 4 but is available in LN

Hi,

Comprehensive solution for segregation of duties required by SOX has been developed by DynaFlow, www.dynaflow-dem.com

cheers

Mic

As we did with over 40 global organizations such as Snap On
Tools, Microchip, Fujitsu, Bio-Rad, Immucor, Coopervision, Komatsu, Juno,
Herman Miller, Flextronics, Zebra, Telair,etc..., DynaFlow is offering to scan your Baan authorizations (DEM or Tools) to identify all Segregation of Duties (SOD) conflicts. These constitute business risks for your organization.

It's an automated process that take only 10 minutes of your time (a simple ASCII file to be generated out of a Baan session) and is offered without cost nor condition.

For more information, visit http://dynaflow-dem.com/DF-NewsLetter_Sep2007.htm . To request your SOD scan, contact us at SOD4Baan@EZ-Process.com .

Regards,


- Pierre B.