[rt-users] RT 3.6 performance problems

[Joby Walker]

Jackie Hamilton wrote:
> mysql> SELECT * FROM ACL WHERE RightName = 'OwnTicket' order by ObjectId;
> +-----+---------------+-------------+-----------+------------+----------+-------------+---------------+
> | id  | PrincipalType | PrincipalId | RightName | ObjectType | ObjectId | DelegatedBy | DelegatedFrom |
> +-----+---------------+-------------+-----------+------------+----------+-------------+---------------+
> | 220 | Group         |           3 | OwnTicket | RT::Queue  |       12 |           0 |             0 |
> +-----+---------------+-------------+-----------+------------+----------+-------------+---------------+
> 
> mysql> select id,Name,Created,LastUpdated,Disabled from Queues where id in (1,3,4,5,6,7,9,10,11,12,13,15);
> +----+------------+---------------------+---------------------+----------+
> | id | Name       | Created             | LastUpdated         | Disabled |
> +----+------------+---------------------+---------------------+----------+
> | 12 | research   | 2005-02-18 15:50:25 | 2005-02-21 12:40:33 |        0 |
> +----+------------+---------------------+---------------------+----------+
> How do I fix this so the "Owner" list doesn't consist of every user in the db? What should I be looking for, here?
> 

This is your problem.  You have given "Everyone" (Principal id 3) the 
right to own ticket in the research queue.


Joby Walker
C&C SSG, University of Washington