[rt-users] Admin permissions

[Christian Forjahn]

Kenneth,

I found out that I have to write my own script like "rtimport.pl". this
script involves a script to give groups SU permissions which is much
better for my needs. As it uses only rt-internal-scripts to edit the
database there should be no harm using it.

As I will also implement a groupmapping and groupsync I will publish it
after being tested. rtimport.pl's groupsync is no solution for me as every
user found in ldap will be added to every group. What I need is a real
sync between ldap and rt's database including SU permissions. I think it
should be finished tomorow.

Thanks everyone for the help.

Best Chris

> Christian,
>
>
> 	I could do it in Oracle, if I wanted to take that risk. However, RT
> maintains extremely sensitive and volatile relationships between various
> tables to maintain consistency in the way those permissions work
> throughout RT that I find it way too risky to mess with permissions on a
> DataBase level. I find it easier, in the long term, to let RT do what RT
> does best when it comes to keeping it's own house in order. Also, I'm
> not sure if mysql has the same DB tables as Oracle so my list of those
> relationships may not help you. Sorry.
>
>
> Kenn
> LBNL
>
> On 7/2/2008 2:07 AM, Christian Forjahn wrote:
>> Doesn´t anybody know howto give a User/Group admin permissions by
>> editing the mysql database? Do you need more information?
>>
>> I use the script "rtimportldap.pl" to import groups from ldap into the
>> mysql database. Now I want to be able to give a certain group admin
>> permissions. As I cannot login with user root I want to do it directly
>> in the database.
>>
>> Best Chris
>>
>>
>> Christian Forjahn wrote:
>>> Hi all.
>>>
>>> I have installed a rt 3.6.7 on a Linux Server. Now the problem is that
>>> authentication is against a LDAP server running on this system. As I
>>> configured the system to use the login on the webaccess as well as
>>> login
>>> on the rt I cannot give any admin permissions to anyone.
>>> Which tables of the database have to be configured to give a user/group
>>> admin permissions?
>>>
>>> Thank you for your answer.
>>>
>>> Best Chris
>>> _______________________________________________
>>> 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
>>
>> _______________________________________________
>> 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
>>
>
>