This is what you will need to do to promote a Password Server User to Admin using the DB. THis will need to be done in the case of an old admin leaving the company and not promoting anyone prior to leaving.
Note It is highly recommended to create a backup prior to making any adjustments in the database please make a backup following this article prior to proceeding. https://help.scorpionsoft.com/entries/26652108
1.) Connect to the AuthAnvil Databse Server.
2.) Open SQL Management Studio - you can download it here if it is not installed. - https://www.microsoft.com/en-ca/download/details.aspx?id=42299
3.) Connect to the AuuthAnvil Database
4.) Expand Databses > AuthAnvil Password Server > Tables
dbo.Usertable Right Click edit top 200 Rows
6.) In this table find IsAdmin Columnn
7.) Set this value to
8.) Click in any other cell to save this change and then hit the
! at the top of the screen to ensure the save took.
This should now have the user enabled as Org Admin.