I would really like to see a standardized version of your "security app"
uploaded to the JDEList website.
Thanks,
James
James A. Wilson
Technical - CNC
To: James A. Wilson@ANDERSEN WO
cc:
jbouchard@flint-ener Date: 01/29/2002 10:23 AM
gy.com Subject: Re: Setting Up Security
Sent by:
owner-support@jdelis
t.com
Message Mailed On Behalf Of --->
[email protected]
Please respond to jdeapps
Hi Adrian,
I have just finished implementing Security for Xe and I agree with Gordon's
reply regarding Tasks and Roles. As for the standard security, locking
everything up is good but be really careful with the address book security.
Our implementation teams have had lots of issues with having the other
teams/groups seeing their specific information (HR, Payroll, Credit
Collections, etc?).
To cut down on security implementation time, I have developed an MS Access
application that allowed me to enter the security settings directly in the
JDE database without having to deal with JDE. Essentially, all I did was to
take the information from spreadsheets (modified versions of the one on the
JDEList download area), import it in Access, have Access work the logic for
me and export the information into the F00950 table in JDE. The tool I
have created also allows me to merge already created groups together to
create a new group "on the fly". This was really useful as I was able to
enter 73 different groups in about 5 hours and created another 18
consolidated groups in about 4 hours. I have used the tool for AS400 and
for SQL2000 databases so far with the same results. (If there is interest
for the tool, I can probably see if I can put a standardized version of it
in the download area. The app is not perfect but it worked great for me.)
Last thing, if you are going to test security as part of CRP, my advice is
to first get all users to test the system without security, and then once
they are satisfied that their processes are the way they want, have them
redo their testing but with security on this time. What we have allotted
for time was for every 2 days of CRP, you should have 1 day of testing for
security.
Hope this helped a little.
Jacques Bouchard
Xe, Upd 2, SP 17.1, W2K, SQL2K
--------------------------
Visit the forum to view this thread at:
http://www.jdelist.com/cgi-bin/wwwthreads/showflat.pl?Cat
=&Board=Apps&Number=27559
+ - - - - - - - - - - - - - - - - - - - - - - - -+
This is the JDEList One World / Xe® and World 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®
+ - - - - - - - - - - - - - - - - - - - - - - - -+