[rt-users] find all granted access to specific user

[Ruslan Zakirov]

On Mon, Oct 3, 2011 at 11:32 AM, Payam Poursaied <me at payam124.com> 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.