Re: Successful login via SQLPlus produces a server error

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 26 Apr 2005 09:55:33 -0700
Message-ID: <1114534533.218210.319630@g14g2000cwa.googlegroups.com>

g3000 wrote:
> Also my login.sql script is not doing it I checked that out.
>
> I dont get this error via TOAD.

Have you also checked glogin.sql under ORACLE_HOME\sqlplus\admin?

I added this at the end of my glogin.sql DECLARE
BEGIN
dbms_session.set_role('BOGUS_ROLE'); END;
/

and here is the error message from sqlplus logon,

DECLARE
*
ERROR at line 1:

ORA-01919: role 'BOGUS_ROLE' does not exist
ORA-06512: at "SYS.DBMS_SESSION", line 120
ORA-06512: at line 3

Regards
/Rauf Received on Tue Apr 26 2005 - 11:55:33 CDT