Row Security

I have setup row security for the data item UserId in file F0011. I have set up the values as follows
table : F0011 Data item : UserId Fromval : *public Through Val : * Public & add, change, delete & view as No ie N.
Then repeated the same values but only in from & through value entered the user id JDE04 & gave Yes in add change delete & view so that when this user runs application P0011 he can see the batches of his user id only & not that of other user id.
I then logged out & logged in, even deleted file dddict,ddtbl,glbltbl but still the security doesnt work. Could anybody please help me My requirement is, when User JDE04 access application P0011(Review payments) He should see the batches pertaining to his user id & not that of other user id like jde01, jde02 etc etc.

B7332 / WinNT / SQLServer / SP11

Hi there,

I think that the easiest way to achieve the result you are looking for would
be to set up Batch Approval / Post Security Constants (P00241) rather than
to try and use security for this.

Have fun!


Colleen Biddlecombe
Finance Sub Team Leader - Gauteng
Deloitte & Touche Active Era

Building 15 The Woodlands, Woodlands Drive, Woodmead, Sandton
Private Bag X6, Gallo Manor 2052, South Africa
Tel: (011) 209-6805
Fax: (011) 209-6820
Cell: 083-2739503

You need to have *ALL instead of *PUBLIC in the From and Thru values.


From: Jde04 <[email protected]>
Reply-To: [email protected]
To: [email protected]
Subject: Row Security
Date: Sun, 29 Sep 2002 23:55:40 -0700 (PDT)

I have setup row security for the data item UserId in file F0011. I have set
up the values as follows
table : F0011 Data item : UserId Fromval : *public Through Val : * Public &
add, change, delete & view as No ie N.
Then repeated the same values but only in from & through value entered the
user id JDE04 & gave Yes in add change delete & view so that when this user
runs application P0011 he can see the batches of his user id only & not that
of other user id.
I then logged out & logged in, even deleted file dddict,ddtbl,glbltbl but
still the security doesnt work. Could anybody please help me My requirement
is, when User JDE04 access application P0011(Review payments) He should see
the batches pertaining to his user id & not that of other user id like
jde01, jde02 etc etc.

B7332 / WinNT / SQLServer / SP11
--------------------------
To view this thread, go to:
http://www.jdelist.com/ubb/showthreaded.php?Cat=&Board=OW&Number=42601
+ - - - - - - - - - - - - - - - - - - - - - - - -+
This is the JDEList One World® / XE mailing list/forum.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found on the JDEList Forum at
http://www.JDEList.com

JDEList is not affiliated with JDEdwards®

+ - - - - - - - - - - - - - - - - - - - - - - - -+


Peter J Fourie

Re: RE: Row Security

Hi Colleen,

Thanks for your response but could you be more specific as to how
can I use P00241.

SN

Re: Re: Row Security

Hi Peter,

Thanks for your help. I tried *ALL but still its not workign is
there any other way I can do this.

Regards
SN

Hi List,

Let me try to explain what excatly I need. I want to give user
JDE04 access to application P0011 version ZJDE0013. When the user
says find in this application he can see the unposted, posted &
all batches for all the users.
But I want to restrict the user. I mean when USer JDE04 uses this
application he should be able to view only his batches & not the
batches created by other users. So that he cannot add, modify or
delete other users batches.
I tried to do this using row security as I have explained in my
previous mail. But It didnt work. so could anybody please let me
know How can I achieve this.

Regards
SN
B7332 / SQL server / SP11 / Win NT

SN

Let me try and explain it this way...

A) OneWorld Row level security can be setup at 3 levels (1. User, 2. Group
and 3. *PUBLIC)

B) As soon as it finds a rule for a field at one of these levels all other
levels are ignored.

It therefore will not use both your *PUBLIC rule and your JDE04 rule.

So to complete your task try this in your security workbench...

USER/SYSTEM ROLE = *PUBLIC

File - Field - Value from - Value To - Add-Chg-Del-View
F0011 - UserId - A - ZZZZZZZZZZZ - N-N-N-N

USER/SYSTEM ROLE = JDE04

File - Field - Value from - Value To - Add-Chg-Del-View
F0011 - UserId - A - JDE03 - N-N-N-N
F0011 - UserId - JDE05 - ZZZZZZZZZZZ - N-N-N-N

Hope this makes sense (and works...)

Craig


Craig Potte

Re: RE: Row Security

You forgot the record that allows the user to see his own batches:
File - Field - Value from - Value To - Add-Chg-Del-View
F0011 - UserId - JDE04 - JDE04 - Y-Y-Y-Y