BAQ for users and security groups

Yahoo Archive
1
Maybe try using the Menu Security Report?

--sf

--- In vantage@yahoogroups.com, "Brian Roberts" <broberts@...> wrote:
>
> Its in the UserFile table, GroupList column, but its an encoded list
> like this: "INVGRP~MATMGMT~SHIP" for somebody in 3 groups -- annoying to
> use in a BAQ. The table SecGroup has the master list of groups, but no
> user info.
>
>
>
> Brian.
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of randyweb
> Sent: Thursday, May 26, 2011 12:03 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] BAQ for users and security groups
>
>
>
>
>
> I want to create a BAQ that shows the following:
>
> User Security Groups
> Randy Inventory
> Randy Purchasing
> Jane Payroll
>
> I cannot find the table that stores this information.
>
> Thanks in advance
>
> Randy Weber
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
2
I want to create a BAQ that shows the following:

User Security Groups
Randy Inventory
Randy Purchasing
Jane Payroll

I cannot find the table that stores this information.

Thanks in advance

Randy Weber
3
secgroup

Motty


--- In vantage@yahoogroups.com, "randyweb" <weber.randy@...> wrote:
>
> I want to create a BAQ that shows the following:
>
> User Security Groups
> Randy Inventory
> Randy Purchasing
> Jane Payroll
>
> I cannot find the table that stores this information.
>
> Thanks in advance
>
> Randy Weber
>
4
Its in the UserFile table, GroupList column, but its an encoded list
like this: "INVGRP~MATMGMT~SHIP" for somebody in 3 groups -- annoying to
use in a BAQ. The table SecGroup has the master list of groups, but no
user info.



Brian.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of randyweb
Sent: Thursday, May 26, 2011 12:03 PM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ for users and security groups





I want to create a BAQ that shows the following:

User Security Groups
Randy Inventory
Randy Purchasing
Jane Payroll

I cannot find the table that stores this information.

Thanks in advance

Randy Weber





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