Wednesday, March 21, 2012

How to allow FULLTEXT SEARCH INDEXING to non-admin user (in MSSQL 2000)?

I've tried searching a lot on the net but am not able to find out how to allow a user (not admin/owner) to be able to create & populate the FullText Indexing Catalogs on the tables he creates (in MSSQL 2000) .
Currently although with admin account, I can create FullText Catalogs but I have to provide the permissions to build & populate catalogs to some user, so that he can use FullText Search on his tables.
Please Help.
I'm not very experienced in using SQL, so if you can give a bit of explaination also then it would be really helpfull :-)
Cheers :-)

Hey
So no one knows abt it?

|||You have to be members of sysadmin or db_owner to create sp_fulltext_catalog. The reason is that SQL 2000 catalog resides in file system (that is, outside of sql server). From the securiety's point of view, sql 2000 cannot let a user to create catalog.|||

Although the user has been given db_owner but in Sql Server Enterprise Manager it shows FullText Service with a red Flag (Stopped) & when i try to start it, then it shows the following error --

"An error 1722- (The RPC server is unavailable) occurred while performing this service operation on the MSSearch service."

But logging with admin a/c it shows green Flag (started FullText Service)

Also does activating RPC service have any security issues.

Thanks :-)

No comments:

Post a Comment