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?
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