Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Implement set_local_user - analog of SET LOCAL ROLE #87

Open
mkleczek opened this issue Nov 23, 2024 · 0 comments
Open

Implement set_local_user - analog of SET LOCAL ROLE #87

mkleczek opened this issue Nov 23, 2024 · 0 comments

Comments

@mkleczek
Copy link

SET LOCAL ROLE is used for impersonation by PostgREST (and probably other software as well as it is a common pattern to follow where connections are shared - connection pools etc). It is inherently unsafe though because the possibility of RESET ROLE.

It would be great if we had set_user equivalent for the duration of current transaction only.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant