Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > DEM & Workflow

User login

Frontpage Sponsor

Main

Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
18%
200 - 500 GB
29%
500 - 800 GB
3%
800 - 1200 GB
8%
1200 - 1500 GB
8%
1500 - 2000 GB
11%
> 2000 GB
24%
Total votes: 79

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 10th April 2019, 02:28
Vinnie8283 Vinnie8283 is offline
Junior Member
 
Join Date: Mar 2007
Posts: 3
Vinnie8283 is on a distinguished road
Baan: ERPLN - DB: SQL - OS: XP
Roles by Employee
Baan: ERP LN 6.1

Hi All,

Wondering if I get any advice here - in the table tgbrg820100 Roles by Employee. Each Employee has a list of Roles (AP/AR/GL etc) associated with their User ID

Is there another table in ERP LN that specifies what tables they can access with those roles?

Something similar to the attached picture

Thanks!
Attached Images
File Type: jpg Role Table Access.jpg (50.4 KB, 17 views)
Reply With Quote
Sponsored Links
  #2  
Old 10th April 2019, 14:43
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,383
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Well since we only used 4c4 I can only reference it. Might need to wait for an LN person. There was not a table that contained the actual table by role. What I recall was that once the dem flow was populated and you generated a user it populated all of the tools tables. We really did not have any specific database tables assigned to people. You may just want to check the tools tables to see if when you generate a desktop those are populated. Something to check until an LN user comes along.
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
  #3  
Old 11th April 2019, 22:13
BaanInOhio BaanInOhio is offline
Senior Member
 
Join Date: Oct 2005
Location: Northeast Ohio
Posts: 197
BaanInOhio is on a distinguished road
Baan: Baan 4c4, 5C, LN - DB: Informix, Oracle, SQL - OS: HP UX, Win2K
LN / tools version? If using a recent version of LN tools, you can use the enhanced AMS sessions to get what you need. For each role, you can get users and sessions within the role with permission for each from DEM, including subapplications. Tables, not so easy since each session may affect more than the session's main table.
Reply With Quote
  #4  
Old 21st October 2019, 16:18
kumar.roshan kumar.roshan is offline
Newbie
 
Join Date: Oct 2016
Posts: 2
kumar.roshan is on a distinguished road
Baan: baan iv - DB: sql - OS: windows 7
using tools version 10.7

Hi, we install 10.7 & testing the user authorization. It seems that AMS process changed a bit. Can anyone help to understand the changes done in the latest version or share any document for this.
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
Deleting table references... ruchi.verma Tools Administration & Installation 2 19th August 2008 19:58
More than 1 employee at Work Center jojovalenton Manufacturing & Supply Chain 4 4th October 2007 17:48
Example Roles for Authorizations Sablassville Tools Administration & Installation 0 27th July 2006 01:05
¿Cómo crear roles en Baan V? ocavazosg Forum español 1 6th April 2006 18:58
Employee allocation between workcentres sathasivan Manufacturing & Supply Chain 1 6th May 2005 07:38


All times are GMT +2. The time now is 20:36.


©2001-2018 - Baanboard.com - Baanforums.com