OraFAQ Forum: Server Administration » Implicit Logins & Explicit Logins

Home » RDBMS Server » Server Administration » Implicit Logins & Explicit Logins

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Implicit Logins & Explicit Logins [message #177738]

Fri, 16 June 2006 06:20

janetwilson
Messages: 48
Registered: June 2006
Location: St.Louis

Member

Hi Gurus,

In Oracle there is implicit logins and explicit logins.

Is there any way to differetiate these two.

I mean, which column will help to select only explicit logins.

Regards
Janet Wilson

Report message to a moderator

Re: Implicit Logins & Explicit Logins [message #177741 is a reply to message #177738]

Fri, 16 June 2006 06:26

kmsalih
Messages: 197
Registered: March 2006

Senior Member

Hi Janet,

What did you mean by explicit and implicit?

I think implicit means logon by oracle internally.

Explicit means the user logons from the front end.

Am i correct?

Regards
Salih KM

Report message to a moderator

Re: Implicit Logins & Explicit Logins [message #177744 is a reply to message #177741]

Fri, 16 June 2006 06:54

janetwilson
Messages: 48
Registered: June 2006
Location: St.Louis

Member

Hai Salih,

Thanks for your immediate response.
I want to know who logons by providing a username and password explicitly.

Regards
Janet Wilson

[Updated on: Fri, 16 June 2006 06:55]

Report message to a moderator

Re: Implicit Logins & Explicit Logins [message #177745 is a reply to message #177744]

Fri, 16 June 2006 07:03

kmsalih
Messages: 197
Registered: March 2006

Senior Member

Hi Janet,

Just try this,

Select username , program from v$session where username is not null and program not like '%ORACLE%' and program not in ('emagent.exe','OMS');

This is working in my system.
Sometimes there will be other programs used like perl.exe which we are not using explicity.

Please let me know whether it is working in your system or not.

Salih KM

Report message to a moderator

Re: Implicit Logins & Explicit Logins [message #177747 is a reply to message #177745]

Fri, 16 June 2006 07:06

janetwilson
Messages: 48
Registered: June 2006
Location: St.Louis

Member

Dear Salih,

It's working fine.
The output is like

USERNAME PROGRAM
------------------------------ --------------------
SYS TOAD.exe
SYS sqlplusw.exe

Thanks a lot.

Regards
Janet Wilson

Report message to a moderator

Previous Topic:	Table "rule$" is damged
Next Topic:	Multiple Instances open in oracle 9i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 11:40:18 CDT 2024