Skip to content

Instantly share code, notes, and snippets.

@pixie79
Created September 24, 2018 15:29
Show Gist options
  • Save pixie79/bc2e3e118269dc82a079b4b23616f517 to your computer and use it in GitHub Desktop.
Save pixie79/bc2e3e118269dc82a079b4b23616f517 to your computer and use it in GitHub Desktop.
<dbSystemConfig type="POSTGRESQL">
<schemas>
<schema name="public" />
</schemas>
<extensions>
<extension name="uuid-ossp" />
</extensions>
<environments>
<dbEnvironment
name="docker"
type="DEV"
cleanBuildAllowed="true"
dbHost="localhost"
dbPort="5432"
dbServer="postgres"
defaultUserId="postgres"
defaultPassword="mysecretpassword"
dbSchemaSuffix="">
</dbEnvironment>
</environments>
<groups>
<group name="web_anon" />
<group name="admin" />
</groups>
<permissions>
<permission scheme="TABLE"> <!-- scheme name corresponding to object type "table" -->
<grant users="web_anon" privileges="SELECT" />
<grant users="admin" privileges="INSERT,SELECT,UPDATE,DELETE" />
</permission>
<permission scheme="VIEW">
<grant users="admin,web_anon" privileges="SELECT" />
</permission>
</permissions>
</dbSystemConfig>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment