Today I started learning SQL for the first time and I found this error saying permission denied for schema public which I cannot run the data. How can I fix it?
Popsql is a collaborative sql editor for your team.
Have you the privileges to create table on your database ?
Your user has to be granted appropriate permissions on the database. Ask the database admin for those permissions. If you created the database, then do this as an admin user:
GRANT ALL PRIVILEGES ON DATABASE yourdbname TO yourusername;
It works! Thank you.