[rt-users] SQL query to locate administrators

[Steve Finkelstein]

Thanks for the reply Steve.

Any chance you can point me to information on the RT API? Is this a perl
module that's accessible through CPAN?

Thanks again,

Steve

On 1/10/07, Stephen Turner <sturner at mit.edu> wrote:
>
>
>         From: rt-users-bounces at lists.bestpractical.com
> [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Steve
> Finkelstein
>         Sent: Wednesday, January 10, 2007 3:56 PM
>         To: rt-users at 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)
>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20070111/dc07a12c/attachment.htm>