Creating an SQL Server User ID
5/10/2007
A SQL Server user ID identifies a user within a database. All permissions and ownership of objects within the database are controlled by the user account. A login ID must be associated with a user ID in each database before anyone connecting with that login ID can access objects in the database. By default the login name and the user name are the same.
To create a SQL Server user ID
Start SQL Server Enterprise Manager from the Start menu.
Expand the Microsoft SQL Servers node, and then expand the SQL Server Group node. Your database server registration is located under this node.
Expand the <database server registration> node, and then expand the Databases folder.
Expand the MantisSQLDB folder, and then open the Users icon.
Choose New Database User from the Action menu.
In the Database User Properties – New User dialog box, select the user you want to add from the Login name list.
By default, the User name box is populated with the same information.
Choose the permissions for the user by selecting the appropriate database roles in the Database role membership box. For information, see Database Roles.
Choose OK.
Start SQL Server Enterprise Manager from the Start menu.
Expand the Microsoft SQL Servers node, and then expand the SQL Server Group node. Your database server registration is located under this node.
Expand the <database server registration> node, and then expand the Databases folder.
Expand the MantisSQLDB folder, and then open the Users icon.
Choose New Database User from the Action menu.
In the Database User Properties – New User dialog box, select the user you want to add from the Login name list.
By default, the User name box is populated with the same information.
Choose the permissions for the user by selecting the appropriate database roles in the Database role membership box. For information, see Database Roles.
Choose OK.
In This Section
- Database Roles
Describes database roles.