Toad World® Forums

Logon as SYSDBA only - normal logon fails

Hi,I am trying to logon to an 11g XE database:

sqlplus remco@xe

SQL*Plus: Release 11.2.0.2.0 Beta on Fri Feb 10 12:15:42 2012

Copyright © 1982, 2010, Oracle. All rights reserved.

Enter password:

Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - Beta

SQL>

But if I try to logon to the same database using Toad 9.1.0.8 I cannot logon as normal. Magically, I AM able to logonwith the same account as SYSDBA…

Yet: in SQL*Plus:
SQL> select * from session_roles;

ROLE

CONNECT
RESOURCE

SQL>

And in Toad:

GRANTEE GRANTED_ROLE ADM DEF


REMCO RESOURCE NO YES
REMCO CONNECT NO YES

2 rows selected.

The user used to have SYSDBA granted to him, but as you can see that has been revoked. Right?

Anyone has a suggestion as to what is wrong? Or what am I doing wrong?
Thanks in advance,
Remco