SYS.USER$ select on login (4284152)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

SYS.USER$ select on login
Description

When we connect to a database over TOAD, it seems below select statement is executed automatically. Since the user doesn't have select rights on SYS.USER$, an ORA-1031 is logged on DB side.
How can we avoid this?
SELECT null FROM SYS.USER$ WHERE 0=1 Thanks.
Resolution

There is no way to prevent this query. This is part of Toad's privilege checks.
We are not actually selecting anything. It's select NULL (not any data) from sys.user$ where 0=1 (so no rows would return). In addition, the query is not executed, we only try an OCI Describe on it (which is just a parse, not an execute).
The reason that we check is that there are a few queries which can be slow, but are much faster if rewritten using SYS-owned tables instead of data dictionary views.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title