Voltar
-
Título
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. -
Descrição
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.
Login necessário
é necessário estar conectado e ter um contrato de manutenção atual para visualizar os artigos de conhecimento premium.