© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•4mo ago•
10 replies
jkwok678

Unable to insert into a table

I have this RLS on my
gis
gis
schema with a locations table.
alter policy "Enable all authenticated users to access locations"
on "gis"."locations"
to authenticated
using (
  true
);
alter policy "Enable all authenticated users to access locations"
on "gis"."locations"
to authenticated
using (
  true
);

Trying to insert with
const { data, error } = await supabase
    .schema("gis")
    .from("locations")
    .insert({
      name,
      address,
      owner: ownerId,
      point: `POINT(${longitude} ${latitude})`,
    })
    .select()
    .single();
const { data, error } = await supabase
    .schema("gis")
    .from("locations")
    .insert({
      name,
      address,
      owner: ownerId,
      point: `POINT(${longitude} ${latitude})`,
    })
    .select()
    .single();

I can't insert, - I see
{
    "code": "42501",
    "details": null,
    "hint": null,
    "message": "permission denied for table locations"
}
{
    "code": "42501",
    "details": null,
    "hint": null,
    "message": "permission denied for table locations"
}

Is there another level of security somewhere? I am logged into my app
Supabase banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

Unable to Insert Data into Supabase users Table Due to Row Level Security (RLS)
SupabaseSSupabase / help-and-questions
7mo ago
failing to insert data into my table using dart
SupabaseSSupabase / help-and-questions
4y ago
Unable to insert data in table using edge function
SupabaseSSupabase / help-and-questions
7mo ago
Insert into table, ignore columns that don't exist
SupabaseSSupabase / help-and-questions
4y ago