DENY Full-text Catalog Permissions (Transact-SQL)

permission

Specifies a permission that can be denied on a full-text catalog. Listed below.

ON FULLTEXT CATALOG :: full-text_catalog_name

Specifies the full-text catalog on which the permission is being denied. The scope qualifier "::" is required.

database_principal

Specifies the principal to which the permission is being denied. One of the following:

• database user
  
• database role
  
• application role
  
• database user mapped to a Windows login
  
• database user mapped to a Windows group
  
• database user mapped to a certificate
  
• database user mapped to an asymmetric key
  
• database user not mapped to a server principal.
  

CASCADE

Indicates that the permission being denied is also denied to other principals to which it has been granted by this principal.

denying_principal

Specifies a principal from which the principal executing this query derives its right to deny the permission. One of the following:

• database user
  
• database role
  
• application role
  
• database user mapped to a Windows login
  
• database user mapped to a Windows group
  
• database user mapped to a certificate
  
• database user mapped to an asymmetric key
  
• database user not mapped to a server principal.
  

A full-text catalog is a database-level securable contained by the database that is its parent in the permissions hierarchy. The most specific and limited permissions that can be denied on a full-text catalog are listed below, together with the more general permissions that include them by implication.

Requires CONTROL permission on the full-text catalog. If using the AS option, the specified principal must own the full-text catalog.

Reference

Other Resources

Help and Information