Go Back > Forum > Baan Quick Support: Functional & Technical > Tools Administration & Installation

User login

Frontpage Sponsor


Google search

For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
Installation Wizard into new VRC
Manual into existing VRC
Manual into new VRC
Total votes: 45

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 16th February 2007, 22:26
SOXAuditor SOXAuditor is offline
Junior Member
Join Date: Nov 2005
Posts: 4
SOXAuditor is on a distinguished road
Baan: Baan IVc4 AGS0 - DB: Oracle 9.2 - OS: Windows 2003
Authorization Management System (ttams) module
Baan: iBaanERP 5.0c
DB: SQL Server 2000 SP3
OS: Windows 2000
C/S: None/Unknown

I am trying to understand what is Authorization Management System (ttams) module which was added in Baan 5 and how it relates to user security. For example I see that there is a new set of fields in the tttaad200000 table:

t_crol_2 t_crol_3 t_crol_4 t_crol_5 t_crol_6

that lists "roles" that are assigned to users and it looks like these roles are defined in the tttams200000 table.

How do these link or further restrict the t_role assigned to users in the ttgbrg820xxx tables. DemFlows are used at this instance.
Reply With Quote
Old 17th February 2007, 00:21
ecarceller ecarceller is offline
Join Date: Jul 2004
Location: Scottsdale, AZ, USA
Posts: 95
ecarceller is on a distinguished road
Baan: BaanIVc4 BaanVc - DB: SQLServer2000 Oracle Informix - OS: AIX HPUX Solaris Win2000
The ones in ttaad200 and ttams tables are related to session authorizations. The ones in tgbrg are related to DEM roles.

One tells you what sessions you can execute while the other one determines which sessions you'll see in your menu or dem flowchart.

It does make sense that they match and they are called the same to simplify user administration. However technically they could be completely different. Maybe some one more experienced with DEM can confirm this but there might even be a way to generate authorization roles based on DEM roles.

This is just a thought: Maybe it'll help if you try to understand this from the application perspective before going down to the table level.
Reply With Quote
Old 2nd March 2007, 19:35
SOXAuditor SOXAuditor is offline
Junior Member
Join Date: Nov 2005
Posts: 4
SOXAuditor is on a distinguished road
Baan: Baan IVc4 AGS0 - DB: Oracle 9.2 - OS: Windows 2003
As this is done as part of the audit I don't have access to the application and usually request a dump of tables from the client. So which tables do I need to look at in order for me to see what sessions a user has access to if the are restricted by some role in AMS
Reply With Quote
Old 2nd March 2007, 21:26
NPRao's Avatar
NPRao NPRao is offline
Join Date: Aug 2001
Location: Pacific NW, USA
Posts: 3,059
NPRao will become famous soon enough
Baan: Baan 4-5,5.2(Reger),LN-6.1,Infor LN-10.x - DB: Oracle,MS-SQL - OS: HPUX, Linux, Windows
I am inclined to say if you had access to the session, ttams2400m000 it is easier to interpret the authorization settings and gather all the information than trying to interpret the authorization set for user (if they are linked to multiple roles or if they are company-based or package, module based settings etc).
Attached Images
File Type: jpg ttams2400m000.jpg (39.1 KB, 42 views)
The art of perfection does not lie in doing extraordinary things but, doing ordinary things extraordinarily well. [-N. Prashanth Rao]
How To Ask Questions The Smart Way,BaaNBoard,NPRao
Reply With Quote
Sponsored Links

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
Issues with mimic of database auths. sessions BaanTech Tools Administration & Installation 3 6th February 2017 07:40
system performance module in Baan niteshsharma Performance & Tuning 0 26th November 2003 07:30
Warranty Management & Tracking System EdwinvdBorg Polls and Surveys 0 14th October 2003 09:41
Poll: Warranty Management & Tracking System EdwinvdBorg Project & Services 0 14th October 2003 09:34
Authorization Management System Baan ERP 5.0c Commandeur Tools Administration & Installation 1 10th December 2001 14:04

All times are GMT +2. The time now is 22:58.

©2001-2017 - -