Security By Company & Business Unit

[kpapenfuss]

I know this has been discussed in general in the past, but I was wondering if someone could give me the specifics for setting up row security by company and business unit, i.e., which fields and tables need to be secured. My organization has multiple companies that must be secured from each other. One company can't see any information from another. Also, within each company, we need to secure business units from accessing other business units financial information.

Thank you.


Keith Papenfuss
The Vollrath Co., LLC

 

[WalterD]

Here's a few.... You will may still have to do some User Sec pending on Company.

One Group per User - Gotta love OneWorld


Address Book Master 4 Row Security CostCenter
Address Book Master 4 Row Security CostCenter
Address Book Master 4 Row Security Costcenter
Customer Master by Co Table 4 Row Security Company
Customer Master by Co Table 4 Row Security Company
Customer Ledger 4 Row Security Company
Customer Ledger 4 Row Security Company
Receipts Header File 4 Row Security Company
Receipts Header File 4 Row Security Company
A/R Check Detail File 4 Row Security Company
A/R Check Detail File 4 Row Security Company
Supplier Master 4 Row Security Company
Supplier Master 4 Row Security Company
Accounts Payable Ledger 4 Row Security Company
Accounts Payable Ledger 4 Row Security Company
Accounts Payable Matching Docu 4 Row Security Company
Accounts Payable Matching Docu 4 Row Security Company
Account Ledger 4 Row Security Company
Account Ledger 4 Row Security Company
Program Header 4 Row Security Company
Program Header 4 Row Security Company


Walter De Melo
Mosaic Group Inc.

 

[kpapenfuss]

Thanks for the info, but I am looking for specific table names (Fxxxx) and field names (alias?). Unfortunately, I am a manager, not a techie. I need to give my security person the actual details to set this up.

Thanks again.

Keith Papenfuss
The Vollrath Co., LLC

 

[WalterD]

Here are some that should help you get started
Table Data Item
F0101 CostCenter
F03B01 Company
F03B11 Company
F03B13 Company
F03B14 Company
F0401 Company
F0411 Company
F0414 Company
F0901 Company
F0911 Company


Walter De Melo
Mosaic Group Inc.

 

[WalterD]

F0006 Company
F0010 Company


Walter De Melo
Mosaic Group Inc.

 

[got_to_love_jde]

Keith,
i must disagree. what you need is generalization not specification.
put users into groups and then make entries in the security workbench for each user group.
object name - *all
type - row security
data item - company (search is available for data item)
table - *all

1) from & though - enter company to grant (add-y, change-y, etc.)
2) from & though - enter company range to restrict (add-n, change-n, etc.). probably need at least two entries for this.

they say performance is hampered by row security but it works fine.
dave



NT 4.0 SP5, SQL 7.0, One World B7321 SP12.4

 

[robby_pollard]

Keith,

Here is what I did for our company as it is 21000.

Table Data Item From Value Thru Value Add Change
Delete View
*ALL Company 00001 20999 N N N
N
*ALL Company 22000 99998 N N N
N

Hope this helps,

Robby Pollard
DK Publishing

 

[[email protected]]

What does this type of security do to response time.

 

[Arup_Choudhury]

We are live on JDE Financials. We have set up row security for Companies
and Business units. Not an appreciable change in response time. The
response time is still 2-3 sec. at remote sites with VSAT, even with row
security set.
The reason for not having much change in response time with security setup
is because the OW Security table F98OWSEC is cached at the 1st login.
Unless there is a change in security this table is accessed from RAM.

regards

Arup Choudhury
Lafarge India Limited
Calcutta
India




CLyons
<CLyons@sargentlo To: [email protected]
ck.com> cc:
Sent by: Subject: RE: Security By Company & Business Unit ~~2603:3568
owner-jdelistml@j
delist.com


09/01/2001 10:39
PM
Please respond to
jdelist





What does this type of security do to response time.




--------------------------
To view this thread, visit the JDEList forum at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OW&Number=3568

*************************************************************
This is the JDEList One World / XE Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
*************************************************************