[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