Vantage Security Report

Yahoo Archive
1
I had the same problem trying to respond intelligently to SOx auditors. The Epicor supplied report was too hard to use, way too much data. I created an Excel report using MSQuery via ODBC cross referencing my security groups to my people. I created a list of groups across the top, and users down the side. Where ever a user had a group code in their profile the intersection highlighted green using conditional formatting. I used a if(isna(match(...))) formula to determine whether there was a match returning TRUE or FALSE. My auditors loved it, and it made it easy for me to explain who had what access. It would have to be tailored to your set of security groups, but someone with a little advanced understading of Excel shouldn't have any problem. I can email it to you off-line if you like.

Jim Pratt
Ameridrives
Vantage 8.03.404B

--- In vantage@yahoogroups.com, "dswmaom" <dwalker@...> wrote:
>
> Does anyone have a report that will list all of the security options that a particular user has, or list which users have clearance to a specific function?
>
> We need to get our hands on this information now and don't have a report and are unsure how to actually create one. Can someone throw us a lifeline here?
>
2
Does anyone have a report that will list all of the security options that a particular user has, or list which users have clearance to a specific function?

We need to get our hands on this information now and don't have a report and are unsure how to actually create one. Can someone throw us a lifeline here?
3
What version of vantage are you using. In the 40X series there is a security
report already in place.



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
dswmaom
Sent: Wednesday, April 08, 2009 10:13 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage Security Report



Does anyone have a report that will list all of the security options that a
particular user has, or list which users have clearance to a specific
function?

We need to get our hands on this information now and don't have a report and
are unsure how to actually create one. Can someone throw us a lifeline here?





[Non-text portions of this message have been removed]
4
If you are on version 8, there's a report in System Management - Security Maint. - Reports called "Menu Security Report"
I recommend you do print preview before sending it to the printer because it is a huge report.





________________________________
From: dswmaom <dwalker@...>
To: vantage@yahoogroups.com
Sent: Wednesday, April 8, 2009 9:12:33 AM
Subject: [Vantage] Vantage Security Report


Does anyone have a report that will list all of the security options that a particular user has, or list which users have clearance to a specific function?

We need to get our hands on this information now and don't have a report and are unsure how to actually create one. Can someone throw us a lifeline here?







[Non-text portions of this message have been removed]
5
The more you can limit the better. I agree with the print preview before
hand.



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Tony Hughes
Sent: Wednesday, April 08, 2009 11:00 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Vantage Security Report



If you are on version 8, there's a report in System Management - Security
Maint. - Reports called "Menu Security Report"
I recommend you do print preview before sending it to the printer because it
is a huge report.

________________________________
From: dswmaom <dwalker@lesueurinc. <mailto:dwalker%40lesueurinc.com> com>
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Sent: Wednesday, April 8, 2009 9:12:33 AM
Subject: [Vantage] Vantage Security Report

Does anyone have a report that will list all of the security options that a
particular user has, or list which users have clearance to a specific
function?

We need to get our hands on this information now and don't have a report and
are unsure how to actually create one. Can someone throw us a lifeline here?

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
6
OK - thanks for the heads-up. I was informed that this report wasn't
useable in its current form. It looks to be pretty flexible to me so I'll
need to loop back and find out specifically why it won't work as-is.
Dale.


[Non-text portions of this message have been removed]
7
I just sent through a SOX audit and I was able to run the report and give the auditors the info they needed: who has sysadmin rights, who has the ability to create a customer, who has access to AP/AR setup, etc.

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of dwalker@...
Sent: Wednesday, April 08, 2009 3:10 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Vantage Security Report

OK - thanks for the heads-up. I was informed that this report wasn't
useable in its current form. It looks to be pretty flexible to me so I'll
need to loop back and find out specifically why it won't work as-is.
Dale.


[Non-text portions of this message have been removed]



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links