[rt-users] Strange, long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3 /FastCGI

[Ham MI-ID, Torsten Brumm]

Hi Emmanuel,
just for my understanding: If they have somewhere the right to own ticket and i do a bulk update only in one queue where only 5 people have own ticket rights, all the users will be queried? 

How can i easily check if they (especially the unpriviledged users) have own ticket rights?

Torsten


Kuehne + Nagel (AG & Co.) KG, Geschaeftsleitung: Hans-Georg Brinkmann (Vors.), Uwe Bielang (Stellv.), Bruno Mang, Dirk Blesius (Stellv.), Alfred Manke, Christian Marnetté (Stellv.),  Mark Reinhardt (Stellv.), Jens Wollesen, Rainer Wunn, Sitz: Bremen, Registergericht: Bremen, HRA 21928, USt-IdNr.: DE 812773878, Persoenlich haftende Gesellschaft: Kuehne & Nagel A.G., Sitz: Contern/Luxemburg Geschaeftsfuehrender Verwaltungsrat: Klaus-Michael Kuehne



-----Urspruengliche Nachricht-----
Von: rt-users-bounces at lists.bestpractical.com [mailto:rt-users-bounces at lists.bestpractical.com] Im Auftrag von Emmanuel Lacour
Gesendet: Freitag, 23. Januar 2009 14:51
An: rt-users at lists.bestpractical.com
Betreff: Re: [rt-users] Strange,long running MySQL Query under RT 3.6.5 / MySQL 5.0.67 /Apache2.2.3 /FastCGI

On Fri, Jan 23, 2009 at 02:35:45PM +0100, Ham MI-ID, Torsten Brumm wrote:
> Hi Together,
> it's me again. Has anyone a idea why this query starts on each 
> BulkUpdate Page? I have just fired up this query in query browser and 
> the result is a big list of 1255 Users, mixed priviledged and 
> unpriviledged users, not all user of our DB are listed and i also 
> cross checked, also users are included which have NEVER created a 
> ticket in the queue i started the bulk update (also have no rights 
> here).
> 
> I'm a little lost in space at this moment, any ideas?
> 

Because somewhere in your ACLs they gain OwnTicket right?

_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com Commercial support: sales at bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com