After a text index is created via sp_create_text_index, the administrator must explicitly grant select permissions on the text index proxy table to users or groups who will query the text index.
The user must have select permission on all columns in the text index source in order to be granted select permission on the text index. If the user does not have select permission on even one of the columns in the text index source, the administrator cannot grant select permission on the text index.
If any of the columns in the text index source table are encrypted columns, the administrator should grant select permissions on the text index only to users who have decrypt permission on the encrypted columns. If the user has select permissions on the encrypted columns, but nodecrypt permissions, the administrator should not grant select permission to the text index.
