Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Mass Security Review

Status
Not open for further replies.

tmking

IS-IT--Management
Jan 26, 2006
1
US
I'm trying to perform a review of all menu and user security. Is there a report, script or query that can be run to give all details of user security and of menu locks?

Thanks!
 
There is not a canned report in JDE that will give you all the information that you are looking for. However, you can query the F00950 table, but that will give you just security.

Do you mean menus or tasks? Depending on which you mean I may be able to point you to a couple of tools that may help.

AJ
 
I would start out by looking in the downloads section of jdelist. There is a program out there that will deliver a report on the user/program/menu x-ref. It takes a while to build the information but it does supply some helpful information.

Although I have not seen it yet, I hear that Qsoftware's SeQure allows you to glean some of this information. We are demo-ing it this week, and I may be able to tell you more about it.

AJ
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top