# Cacoo database Command: Check all of port ps aux | grep postgres start Nulab account server ./gradlew cargoRunLocal --debug lsof -i tcp:8080 New database: ```sql ALTER TABLE public.slack_credential OWNER TO postgres; ALTER sequence public.slack_credential_id OWNER TO postgres; ``` For database dev: Grant permission ```sql CREATE ROLE "cacoo-service-legacy" with login PASSWORD "cacoo-service-legacy-password"; GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES ON ALL TABLES IN SCHEMA public to "cacoo-service-integration"; GRANT USAGE ON ALL SEQUENCES IN SCHEMA public to "cacoo-service-integration"; GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA schema_name TO username; GRANT ALL PRIVILEGES ON DATABASE "cacoo_activitylog" TO "cacoo-service-activitylog"; GRANT USAGE ON ALL SEQUENCES IN SCHEMA public to "cacoo-service-activitylog"; ``` create error page when a logged managed account attempts to sign up Remote login to Dev ``` psql -h cacoo.cwqrjfhptuuf.us-east-1.rds.amazonaws.com -p 5432 -U postgres cacoo lDHol7BK9eAXM1dec07kVqvHqsQrvOdb ```