Zurück
-
Titel
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. -
Beschreibung
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.
Anmeldung erforderlich
Sie müssen sich anmelden und über einen gültigen Servicevertrag verfügen, um auf Premium-Wissensartikel zugreifen zu zu dürfen.