row security and web

Hi,
I'm struggling with row security and jas server. My configuration is :
Enterprise Server AS400 V5R2 - EnterpriseOne 8.93 B1
Web Server Windows 2000 - EnterpriseOne 8.93 B1

Configuration of securuty is (Inclusive Security)
For Role "PEOCNC"
*ALL CostCenter ALL ALL Y Y Y Y MCU
*ALL CostCenter ECB ECB Y Y Y Y MCU
*ALL CostCenter 1056 1056 Y Y Y Y MCU
*ALL CostCenter 1056A 1056Z Y Y Y Y MCU

With this setup EnterpriseOne on Terminal server run correctly and shows correct records.
Insted with HTML interface I have a lot of problems. For example on P41026 application where there isn't MCU field on header form (only on QBE) when I push find button all Item/branch (1056, 1052...) are shown.
On P4310 (P3003, P3002....) application where MCU is on form header
1) if I fill 1056 in the field grid shows correct values
2) if I fill 1052 an error "Business Unit Inval" is displayed (I think this iscorrect)
3) if I fill *, all record (1056, 1052...) are displayed (error)

Moreover all the inquiries on MCU via QBE are NOT CORRECT (all records are shown)!!!

Did I forget any configurations ? Did I make configuration errors? is it a jas problem? I don't understand!!!!!!!
Thanks in advance
Gigi

Try resetting caches on the Enterprise Server in "wsj" or bouncing it...

Regards,
Alexander Pastuhov
http://www.pastuhov.com.au/index.htm

Tried yestarday without success.
Gigi

8.93.D1 and E1 both contain updates regarding Row Security and HTML. We are
experiencing some of the same issues. F1 is due out Monday, the 9th so it
may save you some time to do that install. Remember, all SPs are now
cumulative. Hope this helps.





S. Todd Rorie
Technical Manager
Enterprise Business Systems
Enterprise Services
Information Technology Services
Metro Nashville Government
(615) 862-6300 Ext. 77704
(615) 880-1618



_____

From: gigi [mailto:[email protected]]
Sent: Friday, August 06, 2004 5:27 AM
To: [email protected]
Subject: row security and web


Hi,
I'm struggling with row security and jas server. My configuration is :
Enterprise Server AS400 V5R2 - EnterpriseOne 8.93 B1
Web Server Windows 2000 - EnterpriseOne 8.93 B1

Configuration of securuty is (Inclusive Security)
For Role "PEOCNC"
*ALL CostCenter ALL ALL Y Y Y Y MCU
*ALL CostCenter ECB ECB Y Y Y Y MCU
*ALL CostCenter 1056 1056 Y Y Y Y MCU
*ALL CostCenter 1056A 1056Z Y Y Y Y MCU

With this setup EnterpriseOne on Terminal server run correctly and shows
correct records.
Insted with HTML interface I have a lot of problems. For example on P41026
application where there isn't MCU field on header form (only on QBE) when I
push find button all Item/branch (1056, 1052...) are shown.
On P4310 (P3003, P3002....) application where MCU is on form header
1) if I fill 1056 in the field grid shows correct values
2) if I fill 1052 an error "Business Unit Inval" is displayed (I think this
iscorrect)
3) if I fill *, all record (1056, 1052...) are displayed (error)

Moreover all the inquiries on MCU via QBE are NOT CORRECT (all records are
shown)!!!

Did I forget any configurations ? Did I make configuration errors? is it a
jas problem? I don't understand!!!!!!!
Thanks in advance
Gigi


_____


The entire <http://www.jdelist.com/ubb/showflat.php?Cat=&Board=> JDELIST
thread is available for viewing.



This is the JDELIST EnterpriseOne Mailing List.
The instructions on how to unsubscribe from any JDELIST mailing list are
available here <http://www.jdelist.com/unsubscr.shtml> .
JDELIST is not affiliated with JDEdwards(r).

I don't think that resets the security cache for the web.

Works here. That is all I can speak to.





S. Todd Rorie
Technical Manager
Enterprise Business Systems
Enterprise Services
Information Technology Services
Metro Nashville Government
(615) 862-6300 Ext. 77704
(615) 880-1618



_____

From: brother_of_karamazov [mailto:[email protected]]
Sent: Friday, August 06, 2004 9:14 AM
To: [email protected]
Subject: Re: row security and web


I don't think that resets the security cache for the web.

Brother Of Karamazov



_____


The entire <http://www.jdelist.com/ubb/showflat.php?Cat=&Board=> JDELIST
thread is available for viewing.



This is the JDELIST EnterpriseOne Mailing List.
The instructions on how to unsubscribe from any JDELIST mailing list are
available here <http://www.jdelist.com/unsubscr.shtml> .
JDELIST is not affiliated with JDEdwards(r).

Re: RE: row security and web

Todd,
I tested service pack E1, installing one web instance and regenareting for example P41026. But result is the same. I will try with SP F1 next week
Thanks
Gigi

For Role "PEOCNC"
*ALL CostCenter ALL ALL Y Y Y Y MCU - Doesn't this ALLOW all records?
*ALL CostCenter ECB ECB Y Y Y Y MCU
*ALL CostCenter 1056 1056 Y Y Y Y MCU
*ALL CostCenter 1056A 1056Z Y Y Y Y MCU

It looks like you are granting security for ALL records, ECB, 1056 and
1056A through Z.

You may want to try:

For Role "PEOCNC"
*ALL CostCenter ALL ALL N N N N MCU - To DENY all records
*ALL CostCenter ECB ECB Y Y Y Y MCU
*ALL CostCenter 1056 1056 Y Y Y Y MCU
*ALL CostCenter 1056A 1056Z Y Y Y Y MCU

And see if you get only ECB, 1056 and 1056A through Z.

Of course I'm not sure if the Security Engine will look for ALL vs a value
in that field. If you mean A through ZZZZZZZZ then you have conflicting
entries.

You may just want to try:

For Role "*PUBLIC"
*ALL CostCenter ALL ALL N N N N MCU - To DENY all records assuming ALL
means A ZZZZZZZZZZ N N N N MCU

For Role "PEOCNC"
*ALL CostCenter ECB ECB Y Y Y Y MCU
*ALL CostCenter 1056 1056 Y Y Y Y MCU
*ALL CostCenter 1056A 1056Z Y Y Y Y MCU


Good Luck!

Gerald.





gigi
<luigi.sala@gninfor To: [email protected]
matica.com> cc:
Sent by: Subject: row security and web
jdelist-bounces@jde
list.com


08/06/2004 06:23 AM
Please respond to
PeopleSoft®
EnterpriseOne





Hi,
I'm struggling with row security and jas server. My configuration is :
Enterprise Server AS400 V5R2 - EnterpriseOne 8.93 B1
Web Server Windows 2000 - EnterpriseOne 8.93 B1

Configuration of securuty is (Inclusive Security)
For Role "PEOCNC"
*ALL CostCenter ALL ALL Y Y Y Y MCU
*ALL CostCenter ECB ECB Y Y Y Y MCU
*ALL CostCenter 1056 1056 Y Y Y Y MCU
*ALL CostCenter 1056A 1056Z Y Y Y Y MCU

With this setup EnterpriseOne on Terminal server run correctly and shows
correct records.
Insted with HTML interface I have a lot of problems. For example on P41026
application where there isn't MCU field on header form (only on QBE) when I
push find button all Item/branch (1056, 1052...) are shown.
On P4310 (P3003, P3002....) application where MCU is on form header
1) if I fill 1056 in the field grid shows correct values
2) if I fill 1052 an error "Business Unit Inval" is! displayed (I think
this iscorrect)
3) if I fill *, all record (1056, 1052...) are displayed (error)

Moreover all the inquiries on MCU via QBE are NOT CORRECT (all records are
shown)!!!

Did I forget any configurations ? Did I make configuration errors? is it a
jas problem? I don't understand!!!!!!!
Thanks in advance
Gigi



The entire JDELIST thread is available for viewing.



This is the JDELIST EnterpriseOne Mailing List.
The instructions on how to unsubscribe from any JDELIST mailing
list are available here.
JDELIST is not affiliated with JDEdwards®.

No, it wouldn't reset it on the WEB, but it would for the code executed on the Enterprise Server.

I thought these results may have been caused by the possible inconsistencies in cached security between the JAS and E/Server(s).

OW caching may become quite a nightmare, if not managed...

Regards,
Alexander Pastuhov
http://www.pastuhov.com.au/index.htm