RE: Customised message while connecting to a database...

I don't want to try it immediately as you advised,but I thank you very much for this info as I am just looking forward for this.... I also thank Muru for posting this question..

Surendra Tirumala
Oracle DBA
860-654-1322 (work)
860-298-9141 (home)

> -----Original Message-----
> From: ddorr.cs_at_clearstream.com [SMTP:ddorr.cs_at_clearstream.com]
> Sent: Friday, November 03, 2000 7:32 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Customised message while connecting to a database...
>
> I'm not sure this is advisable here, so I think I will be changed in a
> salt
> statue by our beloved goddess ... ( Hi Rachel ;-)
> but if you really want to do this and know what you're doing :
>
> To change the message following ORA-01045 in an english version :
> - go to $ORACLE_HOME/rdbms/mesg/
> - save a copy of oraus.msg & oraus.msb
> - edit oraus.msg and change the text
> - rebuild oraus.msb with the lmsgen tool : $ORACLE_HOME/bin/lmsgen
> oraus.msg
> RDBMS ORA AMERICAN
> - logon to sqlplus and see what happens ...
>
> But, once more, I do not think it is advisable to change the default
> Oracle
> messages.
>
> > ----------
> > From: Murugesan Balakrishnan[SMTP:mail_oracle_at_yahoo.com]
> > Reply To: ORACLE-L_at_fatcity.com
> > Sent: Thursday, November 02, 2000 23:21
> > To: Multiple recipients of list ORACLE-L
> > Subject: Customised message while connecting to a database...
> >
> > Hello Lists,
> >
> > When a 'CREATE SESSION' previlege is not granted to a
> > particular user and when the user tries to connect
> > through sql*plus he gets oracle error message:
> >
> > ORA-01045: user LRDS lacks CREATE SESSION privilege;
> > logon denied.
> >
> > Is there any way to customize this message? For
> > example, 'You are not suppose to connect at this
> > time...if essential please call <phone number>'.
> >
> > Any help would be highly appreciated...
> >
> > TIA,
> > Muru
> >
> > __________________________________________________
> > Do You Yahoo!?
> > From homework help to love advice, Yahoo! Experts has your answer.
> > http://experts.yahoo.com/
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Murugesan Balakrishnan
> > INET: mail_oracle_at_yahoo.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: ddorr.cs_at_clearstream.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Fri Nov 03 2000 - 09:37:20 CST