From oracle-l-bounce@freelists.org Tue Sep 6 05:49:04 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j86An406009344 for ; Tue, 6 Sep 2005 05:49:04 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j86An0IP009329 for ; Tue, 6 Sep 2005 05:49:01 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1B0C01E9410; Tue, 6 Sep 2005 05:48:57 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 09259-03; Tue, 6 Sep 2005 05:48:57 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 92CDD1E93C7; Tue, 6 Sep 2005 05:48:56 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=OyF0E2/wZI633oj1M5Dw7rBs+pHwMOhSTom2z002Vh7IjyuaWhx2Mu4JG8R83fp/wCFQ6DdJFqtpyvYOFJtGUMarA9eG2RQ/nUAQKk0zIcXPAVrXiV9dsvQ0WC/VcsLOkWcdFaz25XnNEzMPut0zeTGAqkUATiEGhO8rxQZqz6Y= Message-ID: Date: Tue, 6 Sep 2005 12:47:07 +0200 From: Dimitar Radoulov To: oracle.tutorials@gmail.com, oracle-l@freelists.org Subject: Re: URGENT: Strange Problem... Please help... In-Reply-To: <01d901c5b2cf$847c4c00$1a03310a@IBME1D11967173> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_41256_11866230.1126003627002" References: <75aa8016050906033434ecd2d5@mail.gmail.com> <01d901c5b2cf$847c4c00$1a03310a@IBME1D11967173> X-archive-position: 25031 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: cichomitiko@gmail.com Precedence: normal Reply-To: cichomitiko@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-4.3 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE autolearn=ham version=2.63 ------=_Part_41256_11866230.1126003627002 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline ... and of course the OS user has to be added to the DBA(Unix)/ORA_DBA(MS)= =20 group. =20 Dimitre On 9/6/05, Radoulov, Dimitre wrote:=20 >=20 > With "/ as sysdba" you get authenticated by the OS, no metter what=20 > user/pass you're giving: > =20 > SQL> conn nouser/nopass as sysdba > Connected. > SQL> sho user > USER is "SYS" > SQL> select username from dba_users where username=3D'NOUSER'; > no rows selected > SQL>=20 > Regards, > Dimitre Radoulov > ------=_Part_41256_11866230.1126003627002 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
... and of course the OS user has to be added to the DB= A(Unix)/ORA_DBA(MS) group.
 

Dimitre
 
On 9/6/05, R= adoulov, Dimitre <cichomiti= ko@gmail.com> wrote:
With "/ as sysdba" you get&n= bsp;authenticated by the OS, no metter what user/pass you're giving:=
 

SQL> conn nouser/nopass as sysdba
Connected.
SQL> sho = user
USER is "SYS"
SQL> select username from dba_users w= here username=3D'NOUSER';
 
no rows selected
 
SQL>
 
 
Regards,
Dimitre Radoulov
 
------=_Part_41256_11866230.1126003627002-- -- http://www.freelists.org/webpage/oracle-l