Last active
December 29, 2015 08:59
-
-
Save scardine/7647178 to your computer and use it in GitHub Desktop.
Delete RT permission that causes too many options at the "Owner" select on Ticket creation screen:
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- Delete any ACL allowing everyone to own ticlets for any queue | |
DELETE FROM ACL WHERE id IN ( | |
SELECT id FROM ACL WHERE RightName='OwnTicket' AND objecttype='RT::Queue' AND principalid IN ( | |
SELECT id FROM Groups WHERE domain='SystemInternal' AND type='Everyone' | |
) | |
); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment