On Mon, Oct 3, 2011 at 11:32 AM, Payam Poursaied <[email protected]> wrote: > Hi > > I’m looking after a way to get all granted access to specific user. In other > word I want to find out, which right has been granted explicitly (i.e. not > to the groups which the user is its member). > > > > I haven’t find anything through the web GUI, but anything in SQL level would > be also appreciated. > > I tried to learn more about ACL, Principals and Users but I could not find > any relevant info.
SELECT u.Name, acl.RightName, acl.ObjectType, acl.ObjectId FROM ACL acl JOIN Groups g ON g.id = acl.PrincipalId AND g.Domain = 'ACLEquivalence' AND g.Type = 'UserEquiv' JOIN Users u ON g.Instance = u.id; +-----------+-----------+------------+----------+ | Name | RightName | ObjectType | ObjectId | +-----------+-----------+------------+----------+ | RT_System | SuperUser | RT::System | 1 | | Nobody | OwnTicket | RT::System | 1 | | root | SuperUser | RT::System | 1 | +-----------+-----------+------------+----------+ > Best Regards > > Payam Poursaied > > -------- > RT Training Sessions (http://bestpractical.com/services/training.html) > * San Francisco, CA, USA — October 18 & 19, 2011 > * Washington DC, USA — October 31 & November 1, 2011 > * Melbourne VIC, Australia — November 28 & 29, 2011 > * Barcelona, Spain — November 28 & 29, 2011 > -- Best regards, Ruslan. -------- RT Training Sessions (http://bestpractical.com/services/training.html) * San Francisco, CA, USA October 18 & 19, 2011 * Washington DC, USA October 31 & November 1, 2011 * Melbourne VIC, Australia November 28 & 29, 2011 * Barcelona, Spain November 28 & 29, 2011
