Return
-
Title
The "Object reference not set to an instance of an object." error is encountered when a user with read-only or full permission runs a query. -
Description
Let's assume there are two users :
pers : with read-only permissions to test schema, does not own any schema
tech: with full permissions and ownership over test schemaSteps to reproduce the issue:Start Toad Data PointConnect to PostgreSQL as pers userRun a simple SELECT query over a table in the test schema in the editorThe "Object reference not set to an instance of an object." error is encounteredConnect to PostgreSQL as a Tech userRun a simple SELECT query over a table in the test schema in the editorThe "Object reference not set to an instance of an object." error is encounteredExpected result: A query runs without an error, since both users have permissions to run SELECT query over tables in test schema.Only user with superuser privileges can run query without an error.
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.