← Back to branch summary

~patrick-hetu/+junk/postgresql-externe

« back to all changes in this revision

Viewing changes to hooks/db-admin-relation-broken

  • Committer: Patrick Hetu
  • Date: 2012-05-24 20:47:36 UTC
  • Revision ID: patrick.hetu@gmail.com-20120524204736-fguobnp0o2pku8ol
initial release

Show diffs side-by-side

added added

removed removed

Lines of Context:
hooks/db-admin-relation-broken
 
1
#!/bin/bash
 
2
 
 
3
[[ -f "$(dirname $0)/common.sh" ]] && source "$(dirname $0)/common.sh"
 
4
 
 
5
juju-log "Relationship with ${database} broken."
 
6
 
 
7
revoke_access() {
 
8
  sudo -su postgres psql -c"revoke all privileges on database ${database} from ${user};"
 
9
  if admin; then
 
10
    sudo -su postgres psql -c"alter user ${user} nocreatedb nocreateuser" 
 
11
  fi
 
12
}
 
13
revoke_access 
 
14
 
 
15
#juju-log "revoked privileges for ${user} on database ${database}"
 
16
#juju-log "revoking failed"