Menu Security

It seems BAQs can't access any data from the Security table, but a data dump or method directive or ODBC connection will be able to. Join Menu.SecCode to Security.SecCode.

Mind that you'll only get what the security is on a particular item, i.e. who has access provided they're able to access the parent menu. To get a picture of what menus a person has access to, you have to look at the security on all the parent menus too. Security's not cumulative, it considers each individual item's security as it goes down the hierarchy. It's easier to output the security at each level and let the reader decide whether a user ultimately has access to a menu (which helps with spotting gaps in security), though it should be in the same order as the Epicor main menu to be useful (a recursive query will make that easier, which SQL Server and Epicor 10 can do).

My approach was a macro-enabled Excel workbook that grabbed a few tables from a data dump, then evaluated the security for each item and wrote out a new worksheet with a menu for each row and user for each column, with each cell indicating whether they had access by security group or individual user or All. I'm sure there's several ways to do a report like that, but having the menus in hierarchical order is particularly important.
Is it possible to put security on certain parts of a form? For example, the part master has many options that can be set, (Part Class, Group, Purchase/Manufactured, etc..). Is it possible to put security on certain items in that form or is it all or nothing? Also, is it possible to put security on any VB forms we create so only certain people can make changes?

Thanks,

Jasper




[Non-text portions of this message have been removed]
I dont think so. I believe Sonoma will allow you to do this.
Jeremy


-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Monday, March 01, 2004 10:49 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] Menu Security


Is it possible to put security on certain parts of a form? For example, the part master has many options that can be set, (Part Class, Group, Purchase/Manufactured, etc..). Is it possible to put security on certain items in that form or is it all or nothing? Also, is it possible to put security on any VB forms we create so only certain people can make changes?

Thanks,

Jasper




[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/links
Yahoo! Groups Links
I am looking for a menu security report that show user's access
rights. I found this link:

You can access this file at the URL:
http://groups.yahoo.com/group/vantage/files/Reports%20-%20Crystal%
20Reports/Mnu0\
01-MenuSecurity.rpt

However, it is written in a version other than what I am running and
will not open. (I am at Vantage 6.10.536. Crystal Reports 8.5.2.718)
Does anyone have a compatible version of the report? I would prefer
Crystal but Progress Report Builder would be OK too.

Thanks

Stan
Mr. Stan: There are a couple of RB security programs in the files
section. I would recommend trying them (they are listed as 5.1 but
it will still work with your 6.1).

DaveO

--- In vantage@yahoogroups.com, "stanchmura" <schmura@...> wrote:
>
> I am looking for a menu security report that show user's access
> rights. I found this link:
>
> You can access this file at the URL:
> http://groups.yahoo.com/group/vantage/files/Reports%20-%20Crystal%
> 20Reports/Mnu0\
> 01-MenuSecurity.rpt
>
> However, it is written in a version other than what I am running
and
> will not open. (I am at Vantage 6.10.536. Crystal Reports
8.5.2.718)
> Does anyone have a compatible version of the report? I would
prefer
> Crystal but Progress Report Builder would be OK too.
>
> Thanks
>
> Stan
>
Thanks for the reply! I tried them and found that for some reason the ones
labeled 5.1 have some issue going on since when previewed or printed, they
reach a point and time out. RB closes abruptly. The one labeled as a V3.0
version seems to work though. It does seem to be in a better format too,
since the 5.1 was returning 50+ pages from my db before bombing out, while
the 3.0 completes at 14. So after a review to be sure I'm not missing
anything, I could be all set.

Thanks again . . .

Stan



_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Dave Olender
Sent: Wednesday, September 26, 2007 8:48 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Menu Security

Mr. Stan: There are a couple of RB security programs in the files
section. I would recommend trying them (they are listed as 5.1 but
it will still work with your 6.1).

DaveO

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,
"stanchmura" <schmura@...> wrote:
>
> I am looking for a menu security report that show user's access
> rights. I found this link:
>
> You can access this file at the URL:
> http://groups.
<http://groups.yahoo.com/group/vantage/files/Reports%20-%20Crystal%25>
yahoo.com/group/vantage/files/Reports%20-%20Crystal%
> 20Reports/Mnu0\
> 01-MenuSecurity.rpt
>
> However, it is written in a version other than what I am running
and
> will not open. (I am at Vantage 6.10.536. Crystal Reports
8.5.2.718)
> Does anyone have a compatible version of the report? I would
prefer
> Crystal but Progress Report Builder would be OK too.
>
> Thanks
>
> Stan
>



[Non-text portions of this message have been removed]
I am trying to find these Menu Securty files but I can't. Am I
looking in the wrong directory or have they be deleted. I even tried
just clicking on the link from the original email and got the file
not found message.


--- In vantage@yahoogroups.com, "Stan Chmura" <schmura@...> wrote:
>
> Thanks for the reply! I tried them and found that for some reason
the ones
> labeled 5.1 have some issue going on since when previewed or
printed, they
> reach a point and time out. RB closes abruptly. The one labeled
as a V3.0
> version seems to work though. It does seem to be in a better
format too,
> since the 5.1 was returning 50+ pages from my db before bombing
out, while
> the 3.0 completes at 14. So after a review to be sure I'm not
missing
> anything, I could be all set.
>
> Thanks again . . .
>
> Stan
>
>
>
> _____
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> Dave Olender
> Sent: Wednesday, September 26, 2007 8:48 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Menu Security
>
> Mr. Stan: There are a couple of RB security programs in the files
> section. I would recommend trying them (they are listed as 5.1 but
> it will still work with your 6.1).
>
> DaveO
>
> --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,
> "stanchmura" <schmura@> wrote:
> >
> > I am looking for a menu security report that show user's access
> > rights. I found this link:
> >
> > You can access this file at the URL:
> > http://groups.
> <http://groups.yahoo.com/group/vantage/files/Reports%20-%20Crystal%
25>
> yahoo.com/group/vantage/files/Reports%20-%20Crystal%
> > 20Reports/Mnu0\
> > 01-MenuSecurity.rpt
> >
> > However, it is written in a version other than what I am running
> and
> > will not open. (I am at Vantage 6.10.536. Crystal Reports
> 8.5.2.718)
> > Does anyone have a compatible version of the report? I would
> prefer
> > Crystal but Progress Report Builder would be OK too.
> >
> > Thanks
> >
> > Stan
> >
>
>
>
> [Non-text portions of this message have been removed]
>
Has anyone deciphered the tables for this?

I am working on an SQL installation so my flexibility in querying is a
little bit better, but I am trying to figure out if there is a good way to
run an SQL query that will allow me to see all menus where the checkbox for
"Allow Access to All Groups and Users" has been checked.

I have not had any luck with this.

My purpose is to allow us to more quickly determine what menu items are new
in an upgrade so that we can make sure appropriate permissions are setup
since the default is to allow everyone access.

The Menu Security Report doesn't seem very effective in general, especially
for this.

thanks


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

M.MENUID, M.MENUDESC, M.PARENTMENUID, M.PROGRAM, M.SECCODE, S.SECURITYMGR,
S.ENTRYLIST, S.NOENTRYLIST, S.DESCRIPTION

FROM PUB.MENU M

INNER JOIN PUB.SECURITY S ON S.SECCODE = M.SECCODE

WHERE M.OPTIONTYPE = 'I'





When EntryList = '*' it indicates the "Allow Access to All Groups/Users."
checkbox is enabled in Menu Maint.



OptionType = "I" filters to only menu items (vs menus and submenus)







_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Techno Babbler
Sent: Monday, May 21, 2012 1:45 PM
To: vantage
Subject: [Vantage] Menu Security





Has anyone deciphered the tables for this?

I am working on an SQL installation so my flexibility in querying is a
little bit better, but I am trying to figure out if there is a good way to
run an SQL query that will allow me to see all menus where the checkbox for
"Allow Access to All Groups and Users" has been checked.

I have not had any luck with this.

My purpose is to allow us to more quickly determine what menu items are new
in an upgrade so that we can make sure appropriate permissions are setup
since the default is to allow everyone access.

The Menu Security Report doesn't seem very effective in general, especially
for this.

thanks

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



_____

size=1 width="100%" noshade color=gray align=center>

No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2176 / Virus Database: 2425/5013 - Release Date: 05/21/12



[Non-text portions of this message have been removed]
Doh! Remove the "PUB."... I'm a lowly Progress user and I forgot to remove
them. This will work below.



SELECT
M.MENUID, M.MENUDESC, M.PARENTMENUID, M.PROGRAM, M.SECCODE, S.SECURITYMGR,
S.ENTRYLIST, S.NOENTRYLIST, S.DESCRIPTION
FROM MENU M
INNER JOIN SECURITY S ON S.SECCODE = M.SECCODE
WHERE M.OPTIONTYPE = 'I'





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Vic Drecchio
Sent: Monday, May 21, 2012 2:01 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Menu Security





SELECT

M.MENUID, M.MENUDESC, M.PARENTMENUID, M.PROGRAM, M.SECCODE, S.SECURITYMGR,
S.ENTRYLIST, S.NOENTRYLIST, S.DESCRIPTION

FROM PUB.MENU M

INNER JOIN PUB.SECURITY S ON S.SECCODE = M.SECCODE

WHERE M.OPTIONTYPE = 'I'

When EntryList = '*' it indicates the "Allow Access to All Groups/Users."
checkbox is enabled in Menu Maint.

OptionType = "I" filters to only menu items (vs menus and submenus)

_____

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Techno Babbler
Sent: Monday, May 21, 2012 1:45 PM
To: vantage
Subject: [Vantage] Menu Security

Has anyone deciphered the tables for this?

I am working on an SQL installation so my flexibility in querying is a
little bit better, but I am trying to figure out if there is a good way to
run an SQL query that will allow me to see all menus where the checkbox for
"Allow Access to All Groups and Users" has been checked.

I have not had any luck with this.

My purpose is to allow us to more quickly determine what menu items are new
in an upgrade so that we can make sure appropriate permissions are setup
since the default is to allow everyone access.

The Menu Security Report doesn't seem very effective in general, especially
for this.

thanks

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

_____

size=1 width="100%" noshade color=gray align=center>

No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2176 / Virus Database: 2425/5013 - Release Date: 05/21/12

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



No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2176 / Virus Database: 2425/5013 - Release Date: 05/21/12



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



I built an Access database for creating more customized reporting on
menu security.



The table Menu is linked to the table Security by the field SecCode.

If the value in the field Security.EntryList = "*" then is has the all
groups and users checkbox checked.

As an FYI, EntryList can be a tilde separated list of security group
IDs.



One of the issues with this approach is that the table Menu has all
possible menu items and not just the ones you are licensed for.

To work around this, I created a table that I populate with menu ids of
modules I don't own so that only see my menu items.

I supposed I could have hook into the BO that creates the menu listing
but I haven't gotten that far yet.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Techno Babbler
Sent: Monday, May 21, 2012 1:45 PM
To: vantage
Subject: [Vantage] Menu Security





Has anyone deciphered the tables for this?

I am working on an SQL installation so my flexibility in querying is a
little bit better, but I am trying to figure out if there is a good way
to
run an SQL query that will allow me to see all menus where the checkbox
for
"Allow Access to All Groups and Users" has been checked.

I have not had any luck with this.

My purpose is to allow us to more quickly determine what menu items are
new
in an upgrade so that we can make sure appropriate permissions are setup
since the default is to allow everyone access.

The Menu Security Report doesn't seem very effective in general,
especially
for this.

thanks

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





[Non-text portions of this message have been removed]
Yep, I got that figured out, thanks a bunch!

On Mon, May 21, 2012 at 2:02 PM, Vic Drecchio
<vic.drecchio@...>wrote:

> Doh! Remove the "PUB."... I'm a lowly Progress user and I forgot to remove
> them. This will work below.
>
>
>
> SELECT
> M.MENUID, M.MENUDESC, M.PARENTMENUID, M.PROGRAM, M.SECCODE, S.SECURITYMGR,
> S.ENTRYLIST, S.NOENTRYLIST, S.DESCRIPTION
> FROM MENU M
> INNER JOIN SECURITY S ON S.SECCODE = M.SECCODE
> WHERE M.OPTIONTYPE = 'I'
>
>
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of
> Vic Drecchio
> Sent: Monday, May 21, 2012 2:01 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Menu Security
>
>
>
>
>
> SELECT
>
> M.MENUID, M.MENUDESC, M.PARENTMENUID, M.PROGRAM, M.SECCODE, S.SECURITYMGR,
> S.ENTRYLIST, S.NOENTRYLIST, S.DESCRIPTION
>
> FROM PUB.MENU M
>
> INNER JOIN PUB.SECURITY S ON S.SECCODE = M.SECCODE
>
> WHERE M.OPTIONTYPE = 'I'
>
> When EntryList = '*' it indicates the "Allow Access to All Groups/Users."
> checkbox is enabled in Menu Maint.
>
> OptionType = "I" filters to only menu items (vs menus and submenus)
>
> _____
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf Of
> Techno Babbler
> Sent: Monday, May 21, 2012 1:45 PM
> To: vantage
> Subject: [Vantage] Menu Security
>
> Has anyone deciphered the tables for this?
>
> I am working on an SQL installation so my flexibility in querying is a
> little bit better, but I am trying to figure out if there is a good way to
> run an SQL query that will allow me to see all menus where the checkbox for
> "Allow Access to All Groups and Users" has been checked.
>
> I have not had any luck with this.
>
> My purpose is to allow us to more quickly determine what menu items are new
> in an upgrade so that we can make sure appropriate permissions are setup
> since the default is to allow everyone access.
>
> The Menu Security Report doesn't seem very effective in general, especially
> for this.
>
> thanks
>
> [Non-text portions of this message have been removed]
>
> _____
>
> size=1 width="100%" noshade color=gray align=center>
>
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2012.0.2176 / Virus Database: 2425/5013 - Release Date: 05/21/12
>
> [Non-text portions of this message have been removed]
>
>
>
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2012.0.2176 / Virus Database: 2425/5013 - Release Date: 05/21/12
>
>
>
> [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
>
>
>
>


[Non-text portions of this message have been removed]
> Access database
I discovered the Company field is not populated in at least one security tables.
So a BAQ wouldn't retrieve any records.
I had to use ODBC to get the security info I wanted.

--- In vantage@yahoogroups.com, Joe Rojas <jrojas@...> wrote:
>
> I have.
>
>
>
> I built an Access database for creating more customized reporting on
> menu security.
>
>
>
> The table Menu is linked to the table Security by the field SecCode.
>
> If the value in the field Security.EntryList = "*" then is has the all
> groups and users checkbox checked.
>
> As an FYI, EntryList can be a tilde separated list of security group
> IDs.
>
>
>
> One of the issues with this approach is that the table Menu has all
> possible menu items and not just the ones you are licensed for.
>
> To work around this, I created a table that I populate with menu ids of
> modules I don't own so that only see my menu items.
>
> I supposed I could have hook into the BO that creates the menu listing
> but I haven't gotten that far yet.
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Techno Babbler
> Sent: Monday, May 21, 2012 1:45 PM
> To: vantage
> Subject: [Vantage] Menu Security
>
>
>
>
>
> Has anyone deciphered the tables for this?
>
> I am working on an SQL installation so my flexibility in querying is a
> little bit better, but I am trying to figure out if there is a good way
> to
> run an SQL query that will allow me to see all menus where the checkbox
> for
> "Allow Access to All Groups and Users" has been checked.
>
> I have not had any luck with this.
>
> My purpose is to allow us to more quickly determine what menu items are
> new
> in an upgrade so that we can make sure appropriate permissions are setup
> since the default is to allow everyone access.
>
> The Menu Security Report doesn't seem very effective in general,
> especially
> for this.
>
> thanks
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

Vantage 8.03.407

I am trying to create a BAQ to list all the security groups that have access to all the menu items, whether sub-menu or item.
I have looked in the "MENU" table and found the SECCODE field.  I cannot find any other table that references Security Codes.

The Menu Security Report does not show what I want either.


Thanks,

Adam Smith