Creating a read-only database user account for Microsoft SQL Server 2000

Products

• Security Information Manager

Issue/Introduction

 

Resolution

Creating a read-only database user account for Microsoft SQL Server 2000

Collectors that use a database sensor require that you create a read-only database user account so that the collector can query for events.

See Installing collectors that use a database sensor.

To create a read-only database user account for Microsoft SQL Server 2000

1. In the SQL Server Enterprise Manager window, in the left pane, expand Console Root > Microsoft SQL Servers > SQL Server Group.

2. Click the appropriate server host name or click local, and then click (Windows NT) > Security.

3. Right-click Logins, and then click New Login.

4. In the SQL Server Login Properties - New Login dialog box, on the General tab, in the Name box, type the name of the read-only logon account.

5. Click SQL Server Authentication.

6. In the SQL Server Authentication Password box, type a password.

7. In the Database list, select the database name.

8. In the Language list, click <Default>.

9. On the Database Access tab, select the database name.

10. Under Permit in Database Role, click db_datareader.

    This role gives the user read-only data access to the database.

    The role of public is always selected and cannot be cleared.

11. Click OK.

12. Confirm the password for the user that you created, and then click OK.

13. Close the SQL Server Enterprise Manager window.