January 26, 2005 at 10:21 am
I've just recently installed the full-text indexing components on an existing SQL Server 2000 installation, and it works fine if I go in through Enterprise Manager locally as a server administrator. However, if I attach to Enterprise Manager remotely as a user who is a dbo on an individual database and not a server administrator, the full-text option is grayed out. I'm assuming this user needs additional permissions, but I have no idea what they are. Any help would be appreciated.
Thanks,
Gary
January 26, 2005 at 11:11 pm
Gary,
Yes, you are correct. Your user must have the server administrator permission level to admister Full-text Search, even though he has the DBO permission level. Specificly, see SQL Server 2000 BOL title "sp_fulltext_catalog" - "Only members of the sysadmin fixed server role and the db_owner (or higher) fixed database roles can execute sp_fulltext_catalog" as the Enterprise Manager executes sp_fulltext_catalog when maintaining the FT Catalogs.
Hopefully, this level of permissions will be relaxed in SQL Server 2005 to the level of at least DBO, or perhaps to the table owner level...
Regards,
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
John T. Kane
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply