Rebuild Catalog Permission

Hi,

What permission must a user have to Rebuild Catalogs in Full-Text Search?

Thanks.

Adriano.

Adriano,
In order to run sp_fulltext_catalog per the SQL Server 2000 BOL, you need
"Only members of the sysadmin fixed server role and the db_owner (or higher)
fixed database roles can execute sp_fulltext_catalog. " in order rebuild the
FT Catalogs as you will need to run this system stored proc.

Regards,
John

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode test 33Switch to Hybrid Mode Switch to Threaded Mode

1 20th February 10:21 adriano galle dal prá External User Posts: 1	Rebuild Catalog Permission Hi, What permission must a user have to Rebuild Catalogs in Full-Text Search? Thanks. Adriano.

2 20th February 10:21 john kane External User Posts: 1	Rebuild Catalog Permission Adriano, In order to run sp_fulltext_catalog per the SQL Server 2000 BOL, you need "Only members of the sysadmin fixed server role and the db_owner (or higher) fixed database roles can execute sp_fulltext_catalog. " in order rebuild the FT Catalogs as you will need to run this system stored proc. Regards, John