Running the following search in SQL 2008 under my asp.net user context:
select * from sys.dm_fts_parser('FORMSOF(FREETEXT,' + 'DISCREPANCY' + ')', 1033, 0, 0)
Gives me this error:
Msg 297, Level 16, State 1, Line 1
The user does not have permission to perform this action.
Works fine if I run as SA but i really really don't want to have my web app run as SA to get this query to work.... Is there some small grained permission I can grant to my asp.net user to get this query to work?
View Complete Post