[rt-users] Revoking system wide ModifyCustomField in RT4?
Todd Chapman
todd at chaka.net
Mon Sep 26 22:22:40 EDT 2011
Hi RT Users,
Where in RT 4 would I revoke a system-wide ModifyCustomField right for a
user defined group? I believe this right was granted in RT3.
Here's the query that HasRight eventually performs:
mysql> SELECT * FROM ACL, Principals, CachedGroupMembers WHERE Principals.id
= ACL.PrincipalId AND Principals.PrincipalType = 'Group' AND
Principals.Disabled = 0 AND CachedGroupMembers.GroupId = ACL.PrincipalId
AND CachedGroupMembers.GroupId = Principals.id AND
CachedGroupMembers.MemberId = 4538 AND CachedGroupMembers.Disabled = 0 AND
((ACL.ObjectType = 'RT::System' AND ACL.ObjectId = 1) OR (ACL.ObjectType =
'RT::CustomField' AND ACL.ObjectId = 12)) AND (ACL.RightName = 'SuperUser'
OR ACL.RightName = 'ModifyCustomField') \G
*************************** 1. row ***************************
id: 725
PrincipalType: Group
PrincipalId: 686
RightName: ModifyCustomField
ObjectType: RT::System
ObjectId: 1
Creator: 0
Created: NULL
LastUpdatedBy: 0
LastUpdated: NULL
id: 686
PrincipalType: Group
ObjectId: 686
Disabled: 0
id: 9884
GroupId: 686
MemberId: 4538
Via: 9884
ImmediateParentId: 686
Disabled: 0
1 row in set (0.00 sec)
Thanks!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110926/d97bfd33/attachment.htm>
More information about the rt-users
mailing list