Creating a read only user in SQL DB for use with websense collector
Last Updated July 28, 2012
You want to configure websense collector for SSIM and you need to create a read only user account in SQL
A read only database user is required in MSSQL so the logs can be read by the websense collector
Creating a read-only database user account for Microsoft SQL Server Collectors that use a database sensor require that you create a read-only database user account so that the collector can query for events. If you use SQL Server 2000 with Websense Event Collector, the Information Manager must use an existing Websense database account. Introducing Symantec Event Collector for Websense Web Security Suite 13 Installing database drivers on a remote computer In order for the collector to read events from the database, you need to create a readable user that includes the permissions to read events from all child partitions. See “Configuring Websense Web Security Suite to work with the collector” on page 16. To create a read-only database user account for Microsoft SQL Server 2005 1 Start Microsoft SQL Management Studio. 2 In the Connect to Server window, in the Server name box, select the SQL Server 2005 computer on which the database is installed. 3 In the Authentication box, click SQL Server Authentication. 4 In the Login box, type a user name that has permissions to create new accounts. 5 In the Password box, type the password for the user name. 6 Click Connect. 7 Onthe SQLServerManagementStudio window, in the ObjectExplorer pane, right-click Security, and then click New > Login. 8 In the Login-New dialog box, perform the following tasks in the order in which they appear: ■ In the Select a page pane, click General. ■ In the right pane, in the Login name box, type a logon name for the new user. ■ Check SQLServer authentication, type a password for the user, and then confirm the password. ■ Uncheck User must change password at next login. ■ In the Default database box, change nothing. 9 In the Login-New dialog box, in the Select a page pane, click Server Roles. 10 In the right pane, click public. Introducing Symantec Event Collector for Websense Web Security Suite Creating a read-only database user account for Microsoft SQL Server 14 11 In the Login-New dialog box, in the Select a page pane, click User Mapping. On the User Mapping dialog, in the right pane, under Users mapped to this login, make sure that you have selected the databases to read. Under Database role membership for the database, click db_datareader. Note: You need to check all existing Websense databases and assign the new user the db_datareader role with the default schema dbo. For example, if when you create a user, and there are already 21 Websense databases (they have names that begin with wslogdb70), all these databases should be assigned to this new user. 12 Click OK.
Imported Document ID: TECH174204
Subscribing will provide email updates when this Article is updated. Login is required to Subscribe
Thanks for your feedback. Let us know if you have additional comments below. (requires login)
Subscribed to the Article.
Unable to subscribe
Thanks for your additional feedback !!!
Enterprise Support Virtual Agent
Rate Me :
Tell us more:
Welcome! My name is Sami, the Enterprise Support Virtual Agent answering technical support questions.