From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Steve
Finkelstein
Sent: Wednesday, January 10, 2007 3:56 PM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] SQL query to locate administrators
Hi all,
I've been navigating the rt3 database schema and have had a
difficult time of locating a table that has ACL/admin information. I'd
ultimately like to be able to run a query to select all of the users that
have administrative rights on queues. The privilege escalation routine in
RT3 is a bit more complex I'm afraid, but in the off chance that it isn't,
if anyone has any recommendations that would be great.
Thanks all!
________________________________
Steve -
Use a perl script and the RT API to do this. You'll save yourself a lot of
pain...
Steve
----------------------------------------
Stephen Turner
Senior Programmer/Analyst - Client Support Services
MIT Information Services and Technology (IS&T)
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
