[rt-users] Help, root no more a SuperUser

[Николаев Александр]

Boris Jordanov пишет:
> I'm in a trouble. While setting some user rights, it seems I've revoked 
> the superuser right of mu root (UID 1) user. Can someone guide me how to 
> fix this? A nice SQL statement to make my root superuser again?
>
> Thank you in advance.
>
> PS It's urgent :(
> _______________________________________________
> 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
>   
correct me if i'm wrong - there's a record in Principals table for each 
user. u should use principal id for root.
so, first do a
select id from Users where Name LIKE 'root';

remember th id of root user

then

select id from Principals where Object id = [that number u remembered on 
previous step]

remember this number too

then, finally, do a

insert into ACL values (NULL, 'Group', [that number u remembered on 
previous step], 'SuperUser', 'RT::System', 1, 0, 0);

in my case both of id's were 12.
but, i performed lots of different upgrades. so 12 probably won't work.

good luck, and be careful :)

-- 
br, alex