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/