Thanks I'll take a look
*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>
*Quis custodiet ipsos custodes?*
On Mon, Nov 12, 2012 at 9:58 AM, Karen Schoenung <
kschoenung@...> wrote:
*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>
*Quis custodiet ipsos custodes?*
On Mon, Nov 12, 2012 at 9:58 AM, Karen Schoenung <
kschoenung@...> wrote:
> **[Non-text portions of this message have been removed]
>
>
> Jose,
>
> Security.EntryList and Security.NoEntryList (~ delimeted lists) = Allow
> List and Disallow List. Menu file and Security File both include SecCode...
>
> FYI,
> Karen
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Jose Gomez
> Sent: Monday, November 12, 2012 7:54 AM
> To: Vic Drecchio
> Cc: Vantage
> Subject: Re: [Vantage] User Rights
>
> Thanks Vic, but how do you know which Sec Group has access to which menu?
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez
> >
> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
> <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
> On Mon, Nov 12, 2012 at 8:46 AM, Vic Drecchio
> <vic.drecchio@...>wrote:
>
> > Jose, see if this helps. I believe you're SQL.****
> >
> > ** **
> >
> > create view _UserAssignedSecurityGroupsList as****
>
> >
> > SELECT userfile.name, secgroup.secgroupdesc, secgroup.secgroupcode,
> > userfile.dcduserid FROM UserFile CROSS JOIN SecGroup WHERE
> > (userfile.grouplist LIKE '%' + secgroup.secgroupcode + '~%') OR****
> >
> > (userfile.grouplist LIKE '%' + secgroup.secgroupcode)****
> >
> > ** **
> >
> > *From:* vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] *On
> > Behalf Of *Jose Gomez
> > *Sent:* Monday, November 12, 2012 8:43 AM
> > *To:* Vantage
> > *Subject:* [Vantage] User Rights****
> >
> > ** **
> >
> > ****
>
> >
> > Does anyone have a user rights reports they wouldn't mind sharing?
> > Or alternatively does anyone know which tables / the correlation
> > between them will give me this information.
> >
> > the UserFile, SecGroup and Menu Table don't seem to have any
> > relationship
> >
> > *Jose C Gomez*
> > *Software Engineer*
> > *
> > *
> > *
> > *T: 904.469.1524 mobile
> > E: jose@...
> > http://www.josecgomez.com
> > <http://www.linkedin.com/in/josecgomez>
> > <http://www.facebook.com/josegomez
> > >
> > <http://www.google.com/profiles/jose.gomez>
> > <http://www.twitter.com/joc85>
> > <http://www.josecgomez.com/professional-resume/>
> > <http://www.josecgomez.com/feed/>
> > <http://www.usdoingstuff.com>
> >
> > *Quis custodiet ipsos custodes?*
> >
> > [Non-text portions of this message have been removed]****
> >
> > ****
>
> >
> > No virus found in this message.
> > Checked by AVG - www.avg.com
> > Version: 2012.0.2221 / Virus Database: 2441/5389 - Release Date:
> > 11/11/12*
> > ***
>
> >
> > No virus found in this message.
> > Checked by AVG - www.avg.com
> > Version: 2012.0.2221 / Virus Database: 2441/5389 - Release Date:
> > 11/11/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
>
>
>