79554069

Date: 2025-04-03 21:51:04
Score: 1.5
Natty:
Report link

when you GRANT ALL PRIVILEGES ON [ALL TABLES IN] SCHEMA public TO testuser in fact does not grant you all privileges, including CREATE privileges, it gives you permission to access existing tables not to create new. Changing the owner ALTER DATABASE test_db OWNER TO testuser, enables other privileges (including CREATE). To solve this I think you can do GRANT USAGE, CREATE ON SCHEMA public TO testuser . let me know you have more doubts

Reasons:
  • Has code block (-0.5):
  • Single line (0.5):
  • Starts with a question (0.5): when youin
  • Low reputation (1):
Posted by: João Vaz