Skip to content

sql: Block IMPORT statements for RLS tables #136807

Open
@spilchen

Description

Data ingestion methods other than INSERT could inadvertently bypass RLS policy enforcement. To align with PostgreSQL behavior, we will prevent IMPORT and COPY operations on tables with row-level security (RLS) enabled.

PostgreSQL returns an error similar to this, which we should replicate:

postgres=> COPY cities FROM '/c.csv';  
ERROR:  COPY FROM not supported with row-level security  
HINT:  Use INSERT statements instead.  

Jira issue: CRDB-45262

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Assignees

Labels

A-sql-privilegesSQL privilege handling and permission checks.C-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)T-sql-foundationsSQL Foundations Team (formerly SQL Schema + SQL Sessions)

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions