Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2013
    Posts
    1

    Unanswered: Sybase Auditing Tool

    Hi,

    I am just wondering if anyone out there is familiar with any sybase auditing or scanning tools.

    I am conducting an audit of the users in the db and wish at the minimum to extract a list of all users with their accompanying roles/last logon date/last password change.

    Does anyone know of any way to do this? Apologies, I am a bit of a sybase noob.

  2. #2
    Join Date
    Oct 2002
    Location
    BC, Canada
    Posts
    17
    You should implement a Sybase auditing (see SyBooks Online).

    Once when it is installed you can use sp_audit stored procedure to specify which level of logging you want to implement, which includes users actions that you mentioned.

    Cheers,
    Marin
    Marin Kostadinovic
    ----------------------------
    DBA
    DIMM Info Systems Inc.


  3. #3
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    Have a look at sp_displaylogin

Posting Permissions

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