What is the purpose of a Terraform workspace in either open source of enterprise?

While workspaces do manage collections of infrastructure in separate state files, this is a mechanism to achieve logical separation rather than the ultimate purpose itself.

Terraform workspaces, particularly in Terraform Cloud/Enterprise, are used for the logical separation of infrastructure deployments, such as different environments (development, staging, production) or distinct projects for different business units. While they achieve this by isolating state files, their primary purpose extends to organizing and managing these separate deployments as distinct entities within an organization.

Workspaces are not directly used for grouping security policies; security policies are typically managed by the cloud provider or through other Terraform configurations.

Workspaces do not inherently provide limited access to a cloud environment; access control is managed by IAM policies or similar mechanisms in the cloud provider.