Received: (qmail 22553 invoked from network); 7 Jul 2011 10:50:50 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-85-25-126-90.inaddr.intergenia.de with SMTP; 7 Jul 2011 10:50:45 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 46150E32E78; Thu, 7 Jul 2011 11:49:45 -0400 (EDT) X-Virus-Scanned: Debian amavisd-new at localhost.localdomain Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id jBYkgZ-fFb4J; Thu, 7 Jul 2011 11:49:45 -0400 (EDT) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 83C6EE32DE4; Thu, 7 Jul 2011 11:49:01 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 07 Jul 2011 11:48:20 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A55DCE32E17 for ; Thu, 7 Jul 2011 11:48:19 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 7+zJts2gx+Nm for ; Thu, 7 Jul 2011 11:48:19 -0400 (EDT) Received: from mail-gw0-f51.google.com (mail-gw0-f51.google.com [74.125.83.51]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D367EE32D83 for ; Thu, 7 Jul 2011 11:48:11 -0400 (EDT) Received: by gwj17 with SMTP id 17so560456gwj.10 for ; Thu, 07 Jul 2011 08:48:06 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; bh=c6BMaiDhjQPJjCf/kcDWh9kq2qK3kGorT/Hy2GZdYhw=; b=ufNYWn6MlzS0FQQvb2IafqZtVNUE4ZEj9N8R6xigkoT5bVLon0S32EST8+M+YXp61Q uWbEfzPz3sZBymfPGH1h9jXfJxkoO2o13ZNDL8tl2kYU08BIcqrkLa4xViuDTyC8BTLk UV/hNFFY08hDjfI5+ZSBAKryss5zpnUEp3lC8= MIME-Version: 1.0 Received: by 10.236.186.38 with SMTP id v26mr1121993yhm.415.1310053685305; Thu, 07 Jul 2011 08:48:05 -0700 (PDT) Received: by 10.236.209.98 with HTTP; Thu, 7 Jul 2011 08:48:05 -0700 (PDT) Received: by 10.236.209.98 with HTTP; Thu, 7 Jul 2011 08:48:05 -0700 (PDT) In-Reply-To: References: Date: Thu, 7 Jul 2011 21:18:05 +0530 Message-ID: Subject: Re: SID and Service Name From: Subodh Deshpande To: niall.litchfield@gmail.com Cc: ORACLE-L Content-Type: multipart/alternative; boundary=20cf305e28038ca24104a77ca48a X-archive-position: 37286 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: deshpande.subodh@gmail.com Precedence: normal Reply-To: deshpande.subodh@gmail.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l --20cf305e28038ca24104a77ca48a Content-Type: text/plain; charset=ISO-8859-1 Interesting Which privs has been assigned to the said user On 7 Jul 2011 19:53, "Niall Litchfield" wrote: Someone, somewhere asked me if users connecting to a database using SID in the tnsnames file actually got connected to the SYS$USERS service. I have lost my note of where I was asked this, but oracle-l seems likely. The answer is (at least in 11.2 on Windows) yes. I apologize if this is meaningless to everyone. In the output below SID is my sql prom tnsalias with SID specified in connect descriptor - niall is the service_name variant. I've only edited the output for domain name. SQL >conn niall/niall@sid NIALL @ sid >select service_name from v$session where sid = (select sid from v$mystat where rownum = 1); SERVICE_NAME ---------------------------------------------------------------- SYS$USERS NIALL @ sid >conn niall/niall@niall Connected. NIALL @ niall >select service_name from v$session where sid = (select sid from v$mystat where rownum = 1); SERVICE_NAME ---------------------------------------------------------------- niall.domain.name -- Niall Litchfield Oracle DBA http://www.orawin.info --20cf305e28038ca24104a77ca48a Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable

Interesting
Which privs has been assigned to the said user

On 7 Jul 2011 19:53, "Niall Litchfield&qu= ot; <niall.litchfield@gmai= l.com> wrote:

Someone, somewhere asked me if users connecting= to a database using SID in the tnsnames file actually got connected to the= SYS$USERS service. I have lost my note of where I was asked this, but orac= le-l seems likely. The answer is (at least in 11.2 on Windows) yes. I apolo= gize if this is meaningless to everyone. In the output below SID is my sql = prom tnsalias with SID specified in connect descriptor - niall is the servi= ce_name variant. I've only edited the output for domain name.=A0

SQL >conn= niall/niall@sid

NIALL @ sid >select serv= ice_name from v$session where sid =3D (select sid from v$mystat where rownu= m =3D 1);
=
SERVICE_N= AME
------= ----------------------------------------------------------
SYS$USERS
=

= NIALL @ sid >conn niall/= niall@niall
Connected.
NIALL @ niall >sel= ect service_name from v$session where sid =3D (select sid from v$mystat whe= re rownum =3D 1);

= SERVICE_NAME
------------------------= ----------------------------------------
niall.domain.name=A0



--
Niall Litchfield
Oracle DBA
http://www.orawin.info=

--20cf305e28038ca24104a77ca48a-- -- http://www.freelists.org/webpage/oracle-l