SQL Error: permission denied for schema public [closed]

Question

So i went ahead for the 4 Hour SQL tutorial and really followed the video - failed on first task, not sure why - Using PopSQL

Im suspecting the difference in colour of INT and PRIMARY KEY might be indicative, not sure how to fix

Error: permission denied for schema public

CREATE TABLE student 
(
    student_id INT PRIMARY KEY,
    nama VARCHAR(20),
    major VARCHAR(20)
);

and this came out when I tried to run (I'm suspecting its about the difference in colour)

FAILED

permission denied for schema public LINE 1: ...017bc70-b89b-11ec-ad6c-97c51c55f0a9*/ CREATE TABLE student ( ^

The code I entered

problem continue after I removed the comma as suggested, using POPSQL fyi

Answer 1

Solution 1. Get the ownership of the schema. See: GRANT Schema Permissions

Solution 2. Create a new schema. You will be the owner of the new schema.

CREATE SCHEMA yourScheme;
GO
CREATE TABLE yourScheme.student 
(
   student_id INT PRIMARY KEY,
   nama VARCHAR(20),
   major VARCHAR(20)
);