|
I would like to have multiple administrator accounts so that each person with administrative access to the application can only use their own account. I do not see a way to do that. Is there a way to have multiple administrator accounts?
|
|
|
In version 3.x releases of our web applications, it is possible to create multiple administrative accounts. The 3.x versions of the applications do not have a user interface in the administrative tools for creating, editing or deleting additional admin accounts. If you are experienced with editing database tables directly, you can do this right in your database.
Warning: Do not try this on your own if you are unsure of what you are doing. Running queries or editing data directly in your database can result in permanent loss of data. If you are not perfectly clear on the following steps, get assistance from an experienced database administrator.
To create an additional administrative account, you just need to create an additional record in the tblXUDAdmin table in your database. If you open your existing table, you should see your current administrative accounts listed. To add a new account, just insert a new record and enter the name you wish to use in the admLogin column and set the admPHash column to zero. This will add a new account with a blank password. Be sure to login with the account and set the password to a new value immediately. Never leave passwords blank or at a default value. If you cannot do this through your database management tool, running the following query will add a new account to the database. Just change the new account name in the single quote marks to the desired name.
INSERT INTO tblXUDAdmin (admLogin, admPHash) VALUES ('newaccount', 0)
|