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
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 23rd June 2014, 14:46
D.PavanKumar D.PavanKumar is offline
Junior Member
 
Join Date: Oct 2013
Posts: 16
D.PavanKumar is on a distinguished road
Baan: 6.1 - DB: sql server - OS: windows 7
How to restrict a user through script?
Baan: ERP LN 6.1
C/S: None/Unknown

Hi,
Could anyone help me regarding How to restrict a user through Script. Is there any way to restrict the users using script.

My Client requirement is when 'Business Partner status=Active' (For Normal User) he will not able to modify the table data.

Thanks
Pawan.
Reply With Quote
  #2  
Old 23rd June 2014, 15:19
bhushanchanda's Avatar
bhushanchanda bhushanchanda is offline
Guru
 
Join Date: Sep 2012
Location: India
Posts: 2,320
bhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura about
Baan: LN FP 1-9, 10.4, a little bit of Baan IV - DB: SQL Server 2008, Oracle - OS: Windows Server 2008 R2, Unix
Hi,

This requirement can be easily accomplished if you go by table data authorization. If you still want to do it using script, create a UEDLL for table tccom100 and check in before.before.save section.

Note :- I am assuming you are talking about standard Business Partners session.
__________________
Regards,

Bhushan

Unless you try to do something beyond what you have already mastered, you will never grow!
Reply With Quote
  #3  
Old 26th June 2014, 09:15
D.PavanKumar D.PavanKumar is offline
Junior Member
 
Join Date: Oct 2013
Posts: 16
D.PavanKumar is on a distinguished road
Baan: 6.1 - DB: sql server - OS: windows 7
Quote:
Originally Posted by bhushanchanda View Post
Hi,

This requirement can be easily accomplished if you go by table data authorization. If you still want to do it using script, create a UEDLL for table tccom100 and check in before.before.save section.

Note :- I am assuming you are talking about standard Business Partners session.
Yes.

I tried it using table data Authorization. But it is not working.

When BP=Active the user will not change the data. means the session will open in read mode (For normal User) and it will apply to all the child tables also.This is the actual requirement given by the client.


Thanks
Pawan
Attached Images
File Type: png 2014-06-26_09-50-11.png (53.9 KB, 16 views)
File Type: png 2014-06-26_10-09-50.png (40.4 KB, 12 views)
Reply With Quote
  #4  
Old 26th June 2014, 11:55
bhushanchanda's Avatar
bhushanchanda bhushanchanda is offline
Guru
 
Join Date: Sep 2012
Location: India
Posts: 2,320
bhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura about
Baan: LN FP 1-9, 10.4, a little bit of Baan IV - DB: SQL Server 2008, Oracle - OS: Windows Server 2008 R2, Unix
Hi,

Check the attached image for how to do it. The snap shows how to make the session read only if status is active. Similarly, do it for Sold to BP table as well and wherever you want.

If any table doesn't have the status field, then you will need to write a UEDLL to restrict the user from modifying the field.
Attached Images
File Type: jpg Role.JPG (76.9 KB, 18 views)
__________________
Regards,

Bhushan

Unless you try to do something beyond what you have already mastered, you will never grow!
Reply With Quote
Sponsored Links
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
baan remote user vs ora_users blanchap Operating Systems & Databases 3 18th May 2009 18:53
Problem with Convert SSA ERP User to Database User instant000 Operating Systems & Databases 1 17th March 2009 18:29
how to restrict a certain user can only logon from certain IP maclezhang Tools Administration & Installation 7 22nd December 2006 12:38
Not authorized to run as user baan positive Tools Administration & Installation 7 29th June 2004 09:56
creating a user in NT srinivas Tools Administration & Installation 4 9th December 2002 11:40


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


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