[SOLVED] Re-adding the Admin level after it has been removed

[chrisplough]

Hello!

Received this one from a friend in the field, after there was a minor accident, resulting in the removal of the Admin Level from an OTM instance. This resulted in every Admin user losing their Admin privileges, so that no one had the rights to re-add it!

In order to resolve, they had to shutdown OTM, log into the OTM DB as glogowner and run the following SQL:

insert into groupmembers(gm_group, gm_member, gm_type) values ('Administration', 'ADMIN', 'R')

Hope this helps someone in the future! Just remember that OTM doesn't restrict you from doing much -- even self-destructing your instance!

Thanks,
Chris