OraFAQ Forum: Server Administration » How to check if a user has ever been used.

Home » RDBMS Server » Server Administration » How to check if a user has ever been used.

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

How to check if a user has ever been used. [message #54833]

Mon, 09 December 2002 09:04

James Briar
Messages: 72
Registered: January 2002
Location: Morden (South London)

Member

Is there any way to tell if a users account has ever been used. For example say a user was created over a month ago how can i tell if anyone has ever logged into it. I've looked at v$session and dba_users but these views don't help.

Report message to a moderator

Re: How to check if a user has ever been used. [message #54835 is a reply to message #54833]

Mon, 09 December 2002 09:21

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

unless u enable auditing u cannot trace that.
but you can find, when the user has done any DDL from dba_objects.last_ddl_time.
other workaround is to look into listener.ora 
it may have entries for every user logged in.
27-NOV-2002 13:11:44 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)[b](USER=magvivek)[/b])(COMMAND=stop)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=135290880)) * stop * 0

Report message to a moderator

Re: How to check if a user has ever been used. [message #54855 is a reply to message #54833]

Tue, 10 December 2002 02:38

James Briar
Messages: 72
Registered: January 2002
Location: Morden (South London)

Member

Hello Mahesh, I've looked through our listener.log and all i want to know is in there. Thanks very much for your reply. Bye James.

Report message to a moderator

Previous Topic:	Lock Wait problem
Next Topic:	Granting Truncate priviledges to Non table owner

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 27 18:32:57 CST 2024