How do I assign additional SQL users to my SQL database? Print

  • 0

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

Was this answer helpful?

« Back