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

Hello,
Popsql is a collaborative sql editor for your team.
Have you the privileges to create table on your database ?
Cordially

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.

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

1 Like

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 ?