:confused: Can anyone help put a little light on DEM reporting?

The age old question..... How can I tell what users have access to a certain session?

I need to know not just can they access it via AMS but do they have access to it via DEM? I can never seem to anwser that question and any help would be greatly appreciated.

Thanks,

Mark

Hej,

I do not know a direct way either. I always used some queries to get to the requested information.

In the table tgbrg520 you will find the sessionname linked to a process. With this processes you can than read the roles they are in (tgbrg340). With that information you will find the users linked to the roles (tgbrg820).

Hope this helps. ;)

If you are using 5.0c, then if you go to the Business Processes session and select Print, one of the formats available is a cross-reference between Process and Role. There are lots of options on the print, so it may take a bit of experimentation, and I think you can only print six roles at a time, but you can get a format that shows you all the process activities a user can access, along with authorisation level.

In BaanIV the generated DEM authorizations are stored in the AMS tables.
So there the AMS tables are enough to look at.

From BaanERP on that is not the case anymore and you could use the report mentioned by Jeff

Is there a way to obtain information on who has access to each of the Baan sessions by user ID? I am running Baan 4c2,and 4c4 on AIX.

You could use Tools session ttadv2431m000.
This because in 4c the DEM authorizations are generated into Tools authorizations, so for an overview you can also use the Tools sessions.