Home > extract-pg-schema > TableSecurityPolicy

TableSecurityPolicy interface

Security policy on a table.

Signature:

export interface TableSecurityPolicy

Properties

Property	Modifiers	Type	Description
commandType		"ALL" | "SELECT" | "INSERT" | "UPDATE" | "DELETE"	Command type the policy applies to. "ALL" if all commands.
isPermissive		boolean	Whether the policy is permissive.
modifiabilityExpression		string | null	Modifiability expression of the policy specified by the WITH CHECK clause.
name		string	Name of the security policy.
rolesAppliedTo		string[]	Array of roles the policy is applied to. ["public"] if applied to all roles.
visibilityExpression		string | null	Visibility expression of the policy specified by the USING clause.