A database user can be added using the Server Manager tool on the Server computer.
HOW-TO
Add a Database User
| 1. | Start the Server Manager and select the Database Users tab. |
| 2. | Review the list of existing users and click the Add User button. |
| 3. | Enter a user name (login name) and password. |
| 4. | Select the OK button when finished. The user will appear in the database user list. |
Important: Each user must have a unique user name. The user name is not case sensitive. Choose a secure password that cannot be easily guessed. Note that only the first eight characters of the password are significant and that the password is case sensitive.
The level of access granted to the user can be configured differently for each database. Once the user has been added set a role for the user for each database.
See also: