19 lines
516 B
SQL
19 lines
516 B
SQL
|
DO $$
|
||
|
|
BEGIN
|
||
|
|
IF NOT EXISTS (SELECT FROM pg_roles WHERE rolname = 'ncp_db') THEN
|
||
|
|
CREATE USER ncp_db WITH PASSWORD 'ncpDbApp';
|
||
|
|
END IF;
|
||
|
|
END
|
||
|
|
$$;
|
||
|
|
|
||
|
|
GRANT CONNECT ON DATABASE no_copy_ TO ncp_db;
|
||
|
|
GRANT USAGE ON SCHEMA public TO ncp_db;
|
||
|
|
|
||
|
|
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO ncp_db;
|
||
|
|
GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO ncp_db;
|
||
|
|
|
||
|
|
ALTER DEFAULT PRIVILEGES IN SCHEMA public
|
||
|
|
GRANT ALL ON TABLES TO ncp_db;
|
||
|
|
|
||
|
|
ALTER DEFAULT PRIVILEGES IN SCHEMA public
|
||
|
|
GRANT ALL ON SEQUENCES TO ncp_db;
|