DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: How to find out whether a user logged into the database in last 90 days ?

Hybrid View

  1. #1
    Join Date
    Jan 2002
    Posts
    16

    How to find out whether a user logged into the database in last 90 days ?

    Hi All ,

    I am trying to find out users who have not accessed the database in last 90 days and drop them from the database....

    Please let me know how can I find out this...and also I want to reset/change the passwords every 90 days in the database...how can I automate this ?

    Thanks in advance...

    San
    san

  2. #2
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    You should look into profiles.
    "High Salaries = Happiness = Project Success."

  3. #3
    Join Date
    Apr 2003
    Location
    South Carolina
    Posts
    148
    Profiles is good or you could also use logon triggers and create
    yourself a little audit type table that is written to as users logon and logoff the database (if that is what you are trying to do)

    ..........
    LOGON and LOGOFF triggers can be associated with the database or with a schema. Their attributes include the system event and username, and they can specify simple conditions on USERID and USERNAME.

    LOGON triggers fire after a successful logon of a user.

    LOGOFF triggers fire at the start of a user logoff.

    Gregg

  4. #4
    Join Date
    Jan 2002
    Posts
    16
    Profile for each of the users is default....., Limit for all the resource names in dba_profiles in unlimited....

    Any other view that stores login & logout history ?

    Thanks,
    San
    san

  5. #5
    Join Date
    Jul 2001
    Location
    Slovenia
    Posts
    422
    There are no views that store logon/logoff history by default.
    But you can make it yourself as Gregg sugested!
    Also 'you can look in profiles' does not mean you should look in view dba_profiles and everything is there. It means you should open your documentation on profiles and find how to apply password expiration.
    Tomaž
    "A common mistake that people make when trying to design something completely
    foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width