Menu Security Reports in 8.03

Yahoo Archive
1
This can be done easily with ODBC. Connect with Excel and find the table - I
forget its name, but it is there along with all the tables you typically use
and has all the details you need.

--
Randy Weber
weber.randy@...
(651) 263-1811

http://randallweber.com/


[Non-text portions of this message have been removed]
2
We'd like to produce simple tables of users and what security groups they belong to and security groups and what menus they have access to.

The built-in Security report is almost useless and I can't figure out where to find this in tables.

Anyone have any experience with this?.
3
I have some knowledge of this in 6.1, and the tables appear similar in
9.05. Hopefully this is useful for your version:



You'll need to look at the following tables:

UserFile -- usernames, and groups in GroupList column

Menu -- menu structure, with the security for each menu
item in SecCode column

Security -- details for each SecCode, look at EntryList &
NoEntryList - both lists can contain both usernames & group names



The hard part: if you're relied on hiding a parent menu to secure the
screens under it, then you may find the security for an item appears
wide open, and you'll have to separately check the Menu.ParentMenu
item's security.



Brian.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of CarlH
Sent: Saturday, December 04, 2010 3:43 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Menu Security Reports in 8.03





We'd like to produce simple tables of users and what security groups
they belong to and security groups and what menus they have access to.

The built-in Security report is almost useless and I can't figure out
where to find this in tables.

Anyone have any experience with this?.





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