Β© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabaseβ€’4y agoβ€’
20 replies
Greg

'new row violates row-level security policy for table tickets

Hey i have rls setup with these three options it can only update or select if
(uid() = id)
(uid() = id)
and can only insert when authenticated. but when i send in an insert statement from my program i get
 code: '42501',
  details: null,
  hint: null,
  message: 'new row violates row-level security policy for table "tickets"'
 code: '42501',
  details: null,
  hint: null,
  message: 'new row violates row-level security policy for table "tickets"'


this was my function. the user is signed in

export async function createTicket(ticketdata:any) {
  const { data, error } = await supabase
  .from('tickets')
  .insert([
    { devicetype: ticketdata.deviceType },
    { issuedetails:  ticketdata.issueDetails },
    { issuetype: ticketdata.issueType },
    { priority: ticketdata.priority },
    { ticketname:  ticketdata.ticketName },
  ], { returning: 'minimal' }, { upsert: true })
  if (error) console.error(error)
  else console.log(data)
}

export async function createTicket(ticketdata:any) {
  const { data, error } = await supabase
  .from('tickets')
  .insert([
    { devicetype: ticketdata.deviceType },
    { issuedetails:  ticketdata.issueDetails },
    { issuetype: ticketdata.issueType },
    { priority: ticketdata.priority },
    { ticketname:  ticketdata.ticketName },
  ], { returning: 'minimal' }, { upsert: true })
  if (error) console.error(error)
  else console.log(data)
}
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

New row violates row-level security policy for table
SupabaseSSupabase / help-and-questions
4y ago
New row violates row-level security policy for table objects
SupabaseSSupabase / help-and-questions
4y ago
new row violates row-level security policy for table "credit_transactions"
SupabaseSSupabase / help-and-questions
4mo ago
StorageApiError: new row violates row-level security policy
SupabaseSSupabase / help-and-questions
4mo ago