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.