.delete table policy row_level_security command

Applies to: ✅ Azure Data Explorer

Deletes the row level security policy of a table. For more information, see row level security policy.

Permissions

You must have at least Table Admin permissions to run this command.

.delete table TableName policy row_level_security

Name	Type	Required	Description
TableName	`string`	✔️	The name of the table for which to delete the row level security policy.

Name	Type	Description
PolicyName	`string`	The name of the policy being deleted: RowLevelSecurityPolicy.
EntityName	`string`	The name of the entity for which the policy is deleted. The name follows the format of `[`databaseName`].[`tableName`]`, where databaseName corresponds to the name of the database in which in the table exists, and tableName is the name of the table itself.
Policy	`string`	A JSON representation of the policy object. Upon deletion of the policy, this property is set to `null`.
ChildEntities	`string`	Child entities for which this policy is set. For a table row level security policy, this value is an empty string.
EntityType	`string`	The type of entity for which this policy is set. For a table row level security policy, this value is an empty string.

The following command removes the row level security policy of a table named T:

.delete table T policy row_level_security

Output

PolicyName	EntityName	Policy	ChildEntities	EntityType
RowLevelSecurityPolicy	[database].[T]	null