Permissions to Search on SQL - MOSS 2007

How to provide permissions to Search account on SQL Databa开发者_运维知识库se?

Presuming that you are actually asking what the permissions should be, not how to allocate the permissions in SQL Server, the account used for search should have the dbcreator and the securityadmin server roles in the SSP Search database.

Refer Technet for more details:

Plan for administrative and service accounts (Office SharePoint Server)

In case you do need guidance on setting SQL permissions, refer here:

Security Considerations for Databases and Database Applications (SQL Server 2005)

Security and Protection (SQL Server 2008)