Re: No password prompt for "sqlplus '/ as sysdba"

From: Dave <x_at_x.com>
Date: Mon, 03 Jan 2005 17:10:20 GMT
Message-ID: <00fCd.2231$GG1.1666@text.news.blueyonder.co.uk>

"qazmlp" <qazmlp1209_at_rediffmail.com> wrote in message news:db9bbf31.0501030859.36dbb94b_at_posting.google.com...
> Whenever the user tries to login as "sqlplus '/ as sysdba", there is
> no password prompt given and it is possible for the user to do any
> modification in the important/critical DB tables(includes Tables
> maintained by Oracle).
> This seems dangerous for the Database setup for the application.
>
> What exactly is missing in my Database configurations? Is this was
> what intended? If yes/no, could anybody provide more information?
>
> Thanks!

perfectly normal, you user is part of the os group which is priveleged enough to do that.

If on unix it is most likely dba, windows it will be ORA_DBA, if you dont want people to do it remve that user from the os group Received on Mon Jan 03 2005 - 11:10:20 CST