Error -5501: User Privilege or Object Not Found When Using WHERE Clause in SQL Query
I'm encountering an error with the message 'user lacks privilege or object not found: ID / Error Code: -5501 / State: 42501' specifically when I attempt to use a WHERE clause in my SQL query. I've verified the table and column names, and the user has the appropriate privileges. Despite this, the error persists. What might be causing this issue, especially when I use a WHERE clause, and how can I resolve it? SELECT * FROM "PUBLIC"."usermodule$userdetails" (No SQL Error) SELECT * FROM "PUBLIC"."usermodule$userdetails" WHERE ID = 119345390125395118; (SQL Error)
Nada Juma Albahri
I think @Richard Johnston is right about this. Mendix juristiction stops at the domain model so any permission issues would be related to the database not Mendix. And since you confirmed those perms are OK then it's just not finding that record.
Maybe you already successfully deleted it. If not, where are you getting that ID from? Maybe try sorting those results and scrolling (after narrowing it with some greater than or less than filters). Also something to think about is that you may have the ID for an associated object.