TRITON - Web Security Help
Websense Web Security v7.5

Go to the table of contents Go to the previous page Go to the next page Go to the index View or print as PDF
Troubleshooting > Reporting issues > Configuring user permissions for Microsoft SQL Server

Microsoft SQL Server defines SQL Server Agent roles that govern accessibility of the job framework. The SQL Server Agent jobs are stored in the SQL Server msdb database.
To install Websense Log Server successfully, the user account that owns the Websense database must have membership in one of the following roles in the msdb database:
Use Microsoft SQL Server Management Studio to grant the database user account the necessary permissions to successfully install Log Server.
1.
On the SQL Server machine, go to Start > Programs > Microsoft SQL Server 2005 or 2008 > Microsoft SQL Server Management Studio.
2.
Select the Object Explorer tree, and then go to select Security > Logins.
4.
5.
Select User Mapping and do the following:
a.
Select msdb in database mapping.
c.
Click OK to save your changes.
6.
Select Server Roles, and then select dbcreator. The dbcreator role is created.
7.
Click OK to save your changes.


Go to the table of contents Go to the previous page Go to the next page Go to the index View or print as PDF
Troubleshooting > Reporting issues > Configuring user permissions for Microsoft SQL Server