Managing Database Access and Database Roles
Perform the following steps to grant database access and database roles:
1. |
From the SQL Server Enterprise Manager, click the plus (+) sign next to the server that contains the login.
|
2. |
Click the plus (+) sign next to the Security folder.
|
3. |
Left-click the Logins icon. A list of logins appears in the Result pane.
|
4. |
Right-click the name in the Result pane. From the right-mouse menu, select the Properties menu option. The SQL Server Login Properties dialog box appears.
|
5. |
From the SQL Server Login Properties dialog box, click the Database Access tab (see Figure 9.5).
Figure 9.5. The SQL Server Login Properties dialog box—Database Access tab. |
6. | Left-click a Permit check box. This permits the ... |
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
