PopSQL - permission denied for schema public

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?

1 Like

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;

1 Like

It works! Thank you.

Can you guide me how to do this? I ve got the same problem.


Does the same solution work for your problem? If not, then you have a different problem, in which case go ahead and open a new topic instead.

where to write this code as an admin ?