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

Default public schema #60

Open
jerith opened this issue Mar 17, 2021 · 0 comments
Open

Default public schema #60

jerith opened this issue Mar 17, 2021 · 0 comments

Comments

@jerith
Copy link

jerith commented Mar 17, 2021

All Postgres databases are created with a default public schema that Postgres implicitly uses whenever a schema isn't specified. However, the operator currently operates only on schemas that are explicitly listed in Postgres CRs, which means that PostgresUsers with READ of WRITE privilege levels don't have access to the public schema by default. (This isn't a problem for the OWNER privilege level, because database ownership is sufficient for anything that schema ownership allows.)

Given that non-schema-aware applications are extremely common, I think it would make sense for the schemas list in a Postgres CR to default to ["public"] rather than an empty list. (However, this isn't sufficient on its own. See #61 for details.)

Thanks for all the work on this operator so far. We've found it to be extremely useful. :-)

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