stephenlacy

-- Create the database
CREATE DATABASE your_database_name;

-- Create the user with a password
CREATE USER your_username WITH PASSWORD 'your_password';

-- Grant all current and future permissions on the database to the user
GRANT ALL PRIVILEGES ON DATABASE your_database_name TO your_username;
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO your_username;
GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO your_username;