File: homer_user.sql

package info (click to toggle)
homer-api 5.0.6%2Bdfsg2-3
  • links: PTS, VCS
  • area: main
  • in suites: stretch
  • size: 1,604 kB
  • ctags: 2,439
  • sloc: php: 8,259; sql: 1,212; perl: 984; sh: 318; makefile: 69
file content (8 lines) | stat: -rw-r--r-- 353 bytes parent folder | download | duplicates (4) 
1
2
3
4
5
6
7
8
 
CREATE USER homer_user WITH PASSWORD 'homer_password';
GRANT ALL PRIVILEGES ON DATABASE homer_configuration TO homer_user;
GRANT ALL PRIVILEGES ON DATABASE homer_statistic TO homer_user;
GRANT ALL PRIVILEGES ON DATABASE homer_data TO homer_user;

# please activate pgcrypto as the DBA (postgress)
# psql homer_configuration
# CREATE EXTENSION pgcrypto;