sp_fulltext_catalog Permissions

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gerald Baeck - 26 Nov 2004 20:02 GMT

Hi,

I try to execute the sp_fulltext_catalog procedure from an application which
has only limited rights on the db. Is there any way to execute this
procedure without adding the account to the sysadmin or dbowner server role?
It is very important for securtiy reasons to give this application no
sysadmin rights.

thx, Gerald.

Reply to this Message

Hilary Cotter - 27 Nov 2004 14:28 GMT

No, the best way to do this is through a com component where it instantiates
the SQL DMO library and uses the FullTextCatalog2 class, or use
impersonation using .Net. These of course mean shelling out to a program or
using sp_OACreate.

Note, that in my tests dbo rights are sufficient.

Signature

Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html

> Hi,
>
[quoted text clipped - 5 lines]
>
> thx, Gerald.

Reply to this Message

John Kane - 27 Nov 2004 21:01 GMT

Gerald,
Unfortunately, no as the BOL for sp_fulltext_catalog states:

"Permissions
Only members of the sysadmin fixed server role and the db_owner (or higher)
fixed database roles can execute sp_fulltext_catalog. "

You might want to consider using a SQLServerAgent job to do this for your
application.
Regards,
John

> Hi,
>
[quoted text clipped - 5 lines]
>
> thx, Gerald.

Reply to this Message