Full-Text Searching

13 Sep 2006 8:46 PM

Warren

I have installed Full-Text Searching on our SQL Server 2000 server.
Question: I have a developer that connects using a local copy of SQL Server
EM. But when he wants to add a Full-Text index, etc. The select is grayed
out. What permissions does the developer need? I thought I could give him
DBO rights just to the database he needs to work on...Is this right? I read
somewhere you have to be a member of the sysadmin rolde, And/or DBO to that
particular database...Any help would be appreciated. Since I have sysadmin I
can do it...Is this a permissions problem? If so, where?

Thanks,

Warren

13 Sep 2006 8:56 PM

Warren Brunk

http://msdn2.microsoft.com/en-us/library/ms189520.aspx

Here is your answer...
User must have CREATE FULLTEXT CATALOG permission on the database, or be a
member of the db_owner, or db_ddladmin fixed database roles.

--
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/

Show quote

"Warren" <War***@discussions.microsoft.com> wrote in message
news:8BBF0B9C-2F54-4E89-AA0A-79560C8680FF@microsoft.com...
>I have installed Full-Text Searching on our SQL Server 2000 server.
> Question: I have a developer that connects using a local copy of SQL
> Server
> EM. But when he wants to add a Full-Text index, etc. The select is
> grayed
> out. What permissions does the developer need? I thought I could give
> him
> DBO rights just to the database he needs to work on...Is this right? I
> read
> somewhere you have to be a member of the sysadmin rolde, And/or DBO to
> that
> particular database...Any help would be appreciated. Since I have
> sysadmin I
> can do it...Is this a permissions problem? If so, where?
>
> Thanks,
>
> Warren