PostgreSQL

-- Create a service account
CREATE USER artie WITH PASSWORD 'password';

-- Grant create on database to the service account, so we can handle creating the necessary schemas.
GRANT CREATE ON DATABASE your_database TO artie;

-- If the schema exists, change the owner to the service account.
-- This is because there are certain DDL operations such as "ALTER TABLE" or "DROP TABLE" that is restricted to the owner.
ALTER SCHEMA schema_name OWNER TO artie;