Skip to content

sql: enable changing the current user of a session with SET ROLE #15005

Closed
#68973
Closed
sql: enable changing the current user of a session with SET ROLE#15005
#68973
Assignees
otan
Labels
A-securityA-sql-pgcompatSemantic compatibility with PostgreSQLA-tools-graphileIssues relating to graphile compatibilityC-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)T-sql-foundationsSQL Foundations Team (formerly SQL Schema + SQL Sessions)
@jordanlewis

Description

@jordanlewis
jordanlewis
opened on Apr 17, 2017

Add support for the SET ROLE command and variants from PostgreSQL. This command sets or resets the user for the current session.

This should also support SET LOCAL ROLE, which changes the role just for the current transaction. This is related to, but not dependent on SET LOCAL for session variables: #32562

At least one client, Flyway, requires support for this syntax. Graphile uses this too.

Epic CRDB-7217

Metadata

Metadata

Assignees

Labels

A-securityA-sql-pgcompatSemantic compatibility with PostgreSQLA-tools-graphileIssues relating to graphile compatibilityC-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