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