DENY Full-text Catalog Permissions (Transact-SQL)

Denies permissions on a full-text catalog.

Transact-SQL Syntax Conventions

Syntax

DENY permission [ ,...n ] 
    ON FULLTEXT CATALOG :: full-text_catalog_name
    TO database_principal [ ,...n ] [ CASCADE ]
        [ AS denying_principal ]

Arguments

• 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.

Remarks

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.

Permissions

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

See Also

Reference

CREATE FULLTEXT CATALOG (Transact-SQL)
DENY (Transact-SQL)
CREATE CERTIFICATE (Transact-SQL)
CREATE ASYMMETRIC KEY (Transact-SQL)
CREATE APPLICATION ROLE (Transact-SQL)

Other Resources

Permissions
Principals
Encryption Hierarchy

Help and Information

Getting SQL Server 2005 Assistance