Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
newAdmin
Starting Member
2 Posts |
 Posted - 2006-09-05 : 02:42:00
|
| I've tried searching a lot on the net but am not able to find out how to allow a user (non-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 a user, so that he can use FullText Search on his tables.Although FullText Search is "Started", any user(other than admin) is unable to use this service coz it shows "Stopped" on their screens.I read on msdn that in mssql 2005, it can be done by granting the permission "CREATE FULLTEXT CATALOG"But how to do that is not mentioned. Also if it is possible in mssql 2000.Please Help.Cheers :-) |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2006-09-05 : 05:54:31
|
| Could you approach it from another angle?....create a SP to populate the FT Catalog and grant the non-admin user access to execute (or schedule) the FT SP. I'm not familiar with the details of FT, so I'm not sure this will work .... but in principle it should. Alternatively create a SP which runs off the schedule (with the required authority of the system account), which checks a user table for some "go ahead" value. All the user then needs to do is fill in the "go ahead" value and sit back a wait until the next execution of the FT SP. |
 |
|
|
|
|
|
URGENT- Full-Text catalog permission to non-admin