Find all granted access to specific user

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.

Best Regards

Payam Poursaied

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.