title: SQL Sys.dm_fts_index_keywords_by_document VIEW SELECT Permissions Not Working
body: <p>I am making use of FULL Text search and I have implemented it by creating a full text catalog and full text index. In order to satisfy the requirement of showing number of occurences of the search keyword I want to access this dynamic management function 
  dm_fts_index_keywords_by_document (DB_ID('DBNAME'),OBJECT_ID('TABLENAME')) which provides the display term from the file content and its number of occurences.</p>
  
  <p>SELECT  *
  FROM    sys.dm_fts_index_keywords_by_document (DB_ID('DBNAME'),OBJECT_ID('TABLENAME'))</p>
  
  <p>This query statement gets executed without any errors and issues when I ran it by logging in with the login id 'sa' but its failing when i ran it with the user id.</p>
  
  <p>I did try giving SELECT Permissions using </p>
  
  <p>GRANT VIEW SERVER STATE
  GRANT VIEW DATABASE STATE</p>
  
  <p>But no luck. Any help would be highly appreciated.</p>