13 lines
502 B
SQL
13 lines
502 B
SQL
-- Create the admin schema for DocEngine
|
|
CREATE SCHEMA IF NOT EXISTS admin;
|
|
|
|
-- Set the default search path
|
|
ALTER DATABASE document_engine SET search_path TO admin, public;
|
|
|
|
-- Grant privileges
|
|
GRANT ALL ON SCHEMA admin TO postgres;
|
|
GRANT USAGE ON SCHEMA admin TO postgres;
|
|
ALTER DEFAULT PRIVILEGES IN SCHEMA admin GRANT ALL ON TABLES TO postgres;
|
|
ALTER DEFAULT PRIVILEGES IN SCHEMA admin GRANT ALL ON SEQUENCES TO postgres;
|
|
ALTER DEFAULT PRIVILEGES IN SCHEMA admin GRANT ALL ON FUNCTIONS TO postgres;
|