---
description: "sys.security_policies (Transact-SQL)"
title: "sys.security_policies (Transact-SQL) | Microsoft Docs"
ms.custom: ""
ms.date: "06/10/2016"
ms.prod: sql
ms.prod_service: "database-engine, sql-database"
ms.reviewer: ""
ms.technology: system-objects
ms.topic: "reference"
f1_keywords: 
  - "SYS.SECURITY_POLICIES_TSQL"
  - "SECURITY_POLICIES_TSQL"
  - "SYS.SECURITY_POLICIES"
  - "SECURITY_POLICIES"
dev_langs: 
  - "TSQL"
helpviewer_keywords: 
  - "sys.security_policies catalog view"
  - "security_policies catalog view"
ms.assetid: 35362f5b-e601-4049-9e1d-c5307e823831
author: VanMSFT
ms.author: vanto
monikerRange: "=azuresqldb-current||>=sql-server-2016||=azure-sqldw-latest||>=sql-server-linux-2017||=azuresqldb-mi-current"
---
# sys.security_policies (Transact-SQL)
[!INCLUDE [sqlserver2016-asdb-asdbmi-asa](../../includes/applies-to-version/sqlserver2016-asdb-asdbmi-asa.md)]

  Returns a row for each security policy in the database.  
  
|Column name|Data type|Description|  
|-----------------|---------------|-----------------|  
|name|**sysname**|Name of the security policy, unique within the database.|  
|object_id|**int**|ID of the security policy.|  
|principal_id|**int**|ID of the owner of the security policy, as registered to the database. NULL if the owner is determined via the schema.|  
|schema_id|**int**|ID of the schema where the object resides.|  
|parent_object_id|**int**|ID of the object to which the policy belongs. Must be 0.|  
|type|**vachar(2)**|Must be **SP**.|  
|type_desc|**nvarchar(60)**|**SECURITY_POLICY**.|  
|create_date|**datetime**|UTC date the security policy was created.|  
|modify_date|**datetime**|UTC date the security policy was last modified.|  
|is_ms_shipped|**bit**|Always false.|  
|is_enabled|**bit**|Security policy specification state:<br /><br /> 0 = disabled<br /><br /> 1 = enabled|  
|is_not_for_replication|**bit**|Policy was created with the NOT FOR REPLICATION option.|  
|uses_database_collation|**bit**|Uses the same collation as the database.|  
|is_schemabinding_enabled|**bit**|Schemabinding state for the security policy:<br /><br /> 0 or NULL = enabled<br /><br /> 1 = disabled|  
  
## Permissions  
 Principals with the **ALTER ANY SECURITY POLICY** permission have access to all objects in this catalog view as well as anyone with **VIEW DEFINITION** on the object.  
  
## See Also  
 [Row-Level Security](../../relational-databases/security/row-level-security.md)   
 [sys.security_predicates &#40;Transact-SQL&#41;](../../relational-databases/system-catalog-views/sys-security-predicates-transact-sql.md)   
 [CREATE SECURITY POLICY &#40;Transact-SQL&#41;](../../t-sql/statements/create-security-policy-transact-sql.md)   
 [Security Catalog Views &#40;Transact-SQL&#41;](../../relational-databases/system-catalog-views/security-catalog-views-transact-sql.md)   
 [Catalog Views &#40;Transact-SQL&#41;](../../relational-databases/system-catalog-views/catalog-views-transact-sql.md)   
 [Principals &#40;Database Engine&#41;](../../relational-databases/security/authentication-access/principals-database-engine.md)