Who has what on menu security

I thought I had seen a thread on this in the past, but I searched the
YahooGroups archive and couldn't find anything on it. Does anyone know the
table that stores information on which user has access to which modules in
menu security? I've looked at Menu, Security, and UserFile (those are the
ones that seemed the likeliest candidates) but have not found the data, nor
a foreign key that would link me to any other useful table.

Anyone been able to do this?

Jon Hellebuyck
Stremel Manufacturing
Jon,

I link DCDV7.Menu to DCDV7.Security & place fields from that.

Dan Maddox
Computer Operator
Pactiv Corp
v207-756-6448
f207-774-3654

At 02:17 PM 3/5/02 -0600, you wrote:
>I thought I had seen a thread on this in the past, but I searched the
>YahooGroups archive and couldn't find anything on it. Does anyone know the
>table that stores information on which user has access to which modules in
>menu security? I've looked at Menu, Security, and UserFile (those are the
>ones that seemed the likeliest candidates) but have not found the data, nor
>a foreign key that would link me to any other useful table.
>
>Anyone been able to do this?
>
>Jon Hellebuyck
>Stremel Manufacturing
>
>
>
>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
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
At 10:02 PM 3/5/2002 -0500, you wrote:
>Does anyone know the table that stores information on which user has
>access to which modules in menu security? I've looked at Menu, Security,
>and UserFile

Sounds like you're on the right track. Each menu item has a security code
associated with it (Menu.SecCode) That points to a record in the Security
table (Security.SecCode) Each record there has a list of permitted and
denied users and groups (Security.EntryList & NoEntryList) That's where it
gets hairy... the "lists" are long comma delimited strings of both user
ids and group ids, or an asterisk as a match-all wildcard.

Each user has an Id (UserFile.DCDUserID) and list of groups
(UserFile.GroupList) Vantage has to programmatically break out the values
in the lists and do an intersection of the user's data with the EntryList
and NoEntryList to determine if they're allowed to run a menu item.

You can write a report to show the EntryList and NoEntryList for each
security code. But there's no way [or easy way] to show a complete list by
user of what each user has access to. Hopefully though, your security is
setup on groups rather than user Ids?

There was a nice report floating around on one of the download pages that
showed an indented menu structure in the correct sequence, with the
security for each item in Vantage 3.0. But it quit working at 4.0 when
then added the extra level of menus. Did anyone ever update that to work
with 4.0 and up?
Thanks for all the helpful responses on this. Michael Benedict of Crestview
Aerospace actually had the indented menu report about which you spoke and
was kind enough to send it to me. Much appreciated.

Jon Hellebuyck
Stremel Manufacturing

-----Original Message-----
From: Wayne Cox [mailto:wmc20@...]
Sent: Wednesday, March 06, 2002 9:56 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] who has what on menu security


At 10:02 PM 3/5/2002 -0500, you wrote:
>Does anyone know the table that stores information on which user has
>access to which modules in menu security? I've looked at Menu, Security,
>and UserFile

Sounds like you're on the right track. Each menu item has a security code
associated with it (Menu.SecCode) That points to a record in the Security
table (Security.SecCode) Each record there has a list of permitted and
denied users and groups (Security.EntryList & NoEntryList) That's where
it
gets hairy... the "lists" are long comma delimited strings of both user
ids and group ids, or an asterisk as a match-all wildcard.

Each user has an Id (UserFile.DCDUserID) and list of groups
(UserFile.GroupList) Vantage has to programmatically break out the values
in the lists and do an intersection of the user's data with the EntryList
and NoEntryList to determine if they're allowed to run a menu item.

You can write a report to show the EntryList and NoEntryList for each
security code. But there's no way [or easy way] to show a complete list
by
user of what each user has access to. Hopefully though, your security is
setup on groups rather than user Ids?

There was a nice report floating around on one of the download pages that
showed an indented menu structure in the correct sequence, with the
security for each item in Vantage 3.0. But it quit working at 4.0 when
then added the extra level of menus. Did anyone ever update that to work
with 4.0 and up?



Yahoo! Groups Sponsor
ADVERTISEMENT




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

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
I wrote a Report Builder Report which maps out the security 'allowed' and
'not allowed' for each Vantage menu item. Some of the list members may
have my menu security report that I wrote for Vantage 3.0, the new report is
the same format just expanded to cover the New ver. 5.1 Menu Structure.

I will post the report to the list download area later today....


Rick Joslin
V-S Industries
rick.joslin@...





-----Original Message-----
From: Wayne Cox [mailto:wmc20@...]
Sent: Wednesday, March 06, 2002 9:56 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] who has what on menu security


At 10:02 PM 3/5/2002 -0500, you wrote:
>Does anyone know the table that stores information on which user has
>access to which modules in menu security? I've looked at Menu, Security,
>and UserFile

Sounds like you're on the right track. Each menu item has a security code
associated with it (Menu.SecCode) That points to a record in the Security
table (Security.SecCode) Each record there has a list of permitted and
denied users and groups (Security.EntryList & NoEntryList) That's where it
gets hairy... the "lists" are long comma delimited strings of both user
ids and group ids, or an asterisk as a match-all wildcard.

Each user has an Id (UserFile.DCDUserID) and list of groups
(UserFile.GroupList) Vantage has to programmatically break out the values
in the lists and do an intersection of the user's data with the EntryList
and NoEntryList to determine if they're allowed to run a menu item.

You can write a report to show the EntryList and NoEntryList for each
security code. But there's no way [or easy way] to show a complete list by
user of what each user has access to. Hopefully though, your security is
setup on groups rather than user Ids?

There was a nice report floating around on one of the download pages that
showed an indented menu structure in the correct sequence, with the
security for each item in Vantage 3.0. But it quit working at 4.0 when
then added the extra level of menus. Did anyone ever update that to work
with 4.0 and up?




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

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/