We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
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
In our code we put emphasis on the Principle of Least Privilege. Consequently, we have to GRANT USAGE, SELECT ON SEQUENCE in various places.
GRANT USAGE, SELECT ON SEQUENCE
Not knowing much of the internals of pg-migrate, the interface arguably should look something like this:
pg-migrate
pgm.grantOnSequences({ roles: 'myrole', sequences: 'my_table_id_seq', privileges: ['SELECT', 'USAGE'] });
No response
The text was updated successfully, but these errors were encountered:
No branches or pull requests
Description
In our code we put emphasis on the Principle of Least Privilege. Consequently, we have to
GRANT USAGE, SELECT ON SEQUENCE
in various places.Suggested solution
Not knowing much of the internals of
pg-migrate
, the interface arguably should look something like this:Alternative
No response
Additional context
No response
The text was updated successfully, but these errors were encountered: