1. Home
  2. Knowledge Base
  3. On-premise/Customer-Hosted Server
  4. SQL
  5. Assigning an Administrator Privilege to a User From the Server

Assigning an Administrator Privilege to a User From the Server

You must have full access to the server or SQL database to do this task.  You need to open up SQL Management Studio and connect to the database so you can run queries.  You can also use the SQL Tasks from EIOBoard Admin, but that is more difficult so we will focus on using SQL Management Studio in this instance.

Run a SELECT * FROM Users against the database.  Look for an active user that you wish to elevate as an admin.  Note the UserSys.  Make sure the CurrentValue is set to 1 (meaning they are active)

 

 

Now select from UserSecurity.  10000000 is EB Admin and 10000006 is EB Master Admin.  You only need master admin if you wish to create and manage additional organizations which most will not need.

 

 

 

Finally, you need to insert a new row into this table for your user.  For example, this would create a row for the 100000 UserSys (SavText) selected in the above screenshot.

 

INSERT INTO UserSecurity (UserSys, SecurityGroupSys)

VALUES (100000, 10000000)

 

This would add the same person to the master admin security group

INSERT INTO UserSecurity (UserSys, SecurityGroupSys)

VALUES (100000, 10000006)

 

You want to avoid adding duplicate pair entries of UserSys and SecurityGroupSys pairs into that table, so be sure you select from that table before you insert.  Then you can verify the row was inserted because it will say (1) rows affected and you can select from that table to see the UserSecurity row you just added.

 

At this point, you should now be able to login to EIOBoard and have Admin rights.

Was this article helpful?

Related Articles

Need Support?

Can't find the answer you're looking for?
Contact Support