Who's On?

	Membership:
	Latest: Lauren Beeker
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5222

	People Online:
	Visitors: 74
	Members: 0
	Total: 74

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chris Martin	825

Security 9.0 - Security based on Department

1 Replies

0 Subscribed to this topic

18 Subscribed to this forum

Sort:

Author

Messages

Stephane

Basic Member

Posts: 7

1/18/2008 3:11 PM

I'm using security 9.0 and I would like a user have restricted access for a specific department (Employee.Department). I'm able to restrict access on HR11 form and on Drill Explorer but when I print a report all the department are one the list. Is there a way to have only the restricted department on the report ?

John Henley

Posts: 3365

New Poster

Engaged Reader

Avid Reader

1/18/2008 7:19 PM

Reports (standard COBOL, that is) do not use Lawson 9.0 security rules...so the data on the HR (COBOL) reports are only secured down to COMPANY/PROCESS level.
Two possible ways to filter the data shown on a report using 9.0 security would be to 1) publish/burst the COBOL output as a "back office" report in LBI, or 2) create a Crystal report which uses the OLEDB provider (which will use the security rules when filtering records...).