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 |
|
DBADave
Constraint Violating Yak Guru
366 Posts |
 Posted - 2007-10-12 : 10:41:58
|
| I enabled auditing of "permission denied" messages on a server. I am not seeing "EXECUTE permission denied on object 'sp_fulltext_getdata'" whenever the following statements are run.Exec sp_fulltext_table N'[dbo].[TableName]', N'start_incremental'Exec sp_fulltext_catalog N'FullTextCatalogName', N'start_incremental'When I execute the statement as a scheduled job or through query analyzer neither returns an error. However if I enable profiler I receive the error below.2007-10-12 08:12:17.87 spid75 Error: 229, Severity: 14, State: 52007-10-12 08:12:17.87 spid75 EXECUTE permission denied on object 'sp_fulltext_getdata', database 'master', owner 'dbo'..Why is this occurring?Thanks, Dave |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-12 : 11:11:43
|
| Soemone other than sysadmin / db_owner [server role] trying to run it?Kristen |
 |
|
|
DBADave
Constraint Violating Yak Guru
366 Posts |
Posted - 2007-10-12 : 11:24:43
|
| Nope. The command appears to run successfully when executed under the security context of the service account or as SA, but Profiler detects the error. The strange thing is if I create a full-text catalog on another server Profiler does not report an error. The server in question is running SQL Server 2000 EE - SP3a. I have successfully run the commands on 2000 SE - SP3a and 2000 EE - SP4.Thanks, Dave |
|
|
|
|
|
|
EXECUTE permission denied - FullText Incremental