[Error] permission denied for schema public

minsu·2025년 1월 7일
ERROR tests/test_api.py::TestSignUp::test_created - sqlalchemy.exc.ProgrammingError: (psycopg2.errors.InsufficientPrivilege) permission denied for schema public
ERROR tests/test_api.py::TestSignUp::test_bad_request - sqlalchemy.exc.ProgrammingError: (psycopg2.errors.InsufficientPrivilege) permission denied for schema public
ERROR tests/test_api.py::TestSignUp::test_exist_email - sqlalchemy.exc.ProgrammingError: (psycopg2.errors.InsufficientPrivilege) permission denied for schema public

postgreSQL 사용자에게 superuser 권한 부여하여 에러 해결

\du
alter user 사용자명 with superuser

profile
3년차 백엔드 개발자

0개의 댓글