search

jeffutter / dokku-postgresql-plugin

Plugin to setup postgresql accounts for containers deployed with Dokku
GNU General Public License v2.0
35 stars 13 forks source link

Read only user #7

Closed dekz closed 10 years ago

dekz commented 10 years ago

I was thinking that it might be nice to have an additional user with read only permissions.

GRANT SELECT ON ALL TABLES IN SCHEMA public TO abcd

My use case was for sharing database between two dokku deploys with one read only access for testing.

jeffutter commented 10 years ago

I think it is a little out of scope for the plugin to make decisions like this. However I have added a "dokku postgresql:admin_console" and "dokku postgresql:console $APP" commands so that you can easily drop to postgresql shells and do what you need.