# Logon as SYSDBA only - normal logon fails **URL:** \ **Category:** Toad for Oracle & DevOps Toolkit\ **Created:** [February 10, 2012, 5:55am UTC](https://forums.toadworld.com/t/logon-as-sysdba-only-normal-logon-fails/11025 "2012-02-10T05:55:09Z")\ **Posts on this page:** 1\ **Page:** 1
**Author:** ![remco.goris\_296](https://avatars.discourse-cdn.com/v4/letter/r/9d8465/32.png) [@remco.goris\_296](https://forums.toadworld.com/u/remco.goris_296)\ **Post date:** [February 10, 2012, 5:55am UTC](https://forums.toadworld.com/t/logon-as-sysdba-only-normal-logon-fails/11025/1 "2012-02-10T05:55:09Z")
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