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: [EMAIL PROTECTED] >>> >>> >>> 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: [EMAIL PROTECTED] >> >> >> 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: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
