This document details the step-by-step instructions on how to assign a SQL user to a database.
- Use the SQL User Manager to create a new MS SQL user in the MS SQL 2000 Manager section of the hosting control panel
- Connect to the database using Enterprise Manager with the default user
- Expand the Database node
- Locate the database to which you want to add the new SQL User
- Right click on the Users node and select "New Database User"
- In the Database User Properties
- Type the user that you created
- In the Database role membership, select the role you want to grant this user.
- Click OK
