Creating Team Solution Database Users

See Also

Once you have created the Windows NT accounts, SQL Server logins, and database roles for your users, then you can assign the users to your team solution. While the SQL Server login makes it possible for the users to connect to the SQL Server system, a database user account is required to access individual databases.

These user accounts are created within each team solution and are unique to each solution. Before you can create these accounts, you must set up valid Windows NT accounts and SQL Server logins. For more information about creating Windows NT accounts and SQL Server logins, see Windows NT and SQL Server Security.

When creating database user accounts, you have two options:

• Creating Team Solution Database Users with Enterprise Manager
  
  
• Creating Team Solution Database Users with Microsoft Access

After creating the database users, you can assign those users to the roles in your team solution. For details, see Assigning Users to Database Roles.

Creating Database Users with Enterprise Manager

By default, SQL Server Enterprise Manager is installed by SQL Server Setup as part of the server software on computers running Windows NT and as part of the client software on computers running Windows NT, Windows 95, and Windows 98.

To create a database user using the Enterprise Manager

1. From the Start menu, select Programs, then Microsoft SQL Server 7.0, and then Enterprise Manager.
   
   
2. Expand a server group, and then expand a server.
   
   
3. Expand the databases group, and then expand a particular database.
   
   
4. Right-click User, and then click New Database User.
   
   
5. Select a Login Name from the list.
   
   
6. If you wish to designate role membership, enable the roles for the user.
   
   
7. You can select properties on a specific role to add other roles to this role and to view and modify the permissions for this role.
   
   
8. Click OK.

Repeat these steps as necessary to create additional database users.

Creating Database Users with Microsoft Access

Microsoft Access can be used to create database users for your SQL Server database using an Access data project.

To create a database user using Microsoft Access

1. Open your SQL Server database in Access using an Access data project. For details, see Opening your Solution in the Access Workflow Designer in the Access Workflow Designer Developer's Guide.
   
   
2. From the Tools menu, select Security, and then Database Security.

   Note   When an Access data project is loaded and you are working in the Access Workflow Designer, you can access the Security option from the Tools menu in the designer as well.

3. On the Database Users tab, select Add.
   
   
4. Select a Login Name from the list.
   
   
5. If you wish to designate role membership, enable the roles.
   
   
6. You can select properties on a specific role to add other roles to this role and to view and modify the permissions for this role.
   
   
7. Click OK.

Repeat these steps as necessary to create additional database users.