Hi,I am trying to logon to an 11g XE database:
SQL*Plus: Release 18.104.22.168.0 Beta on Fri Feb 10 12:15:42 2012
Copyright © 1982, 2010, Oracle. All rights reserved.
Oracle Database 11g Express Edition Release 22.214.171.124.0 - Beta
But if I try to logon to the same database using Toad 126.96.36.199 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;
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,