Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2004
    Location
    Rayleigh, Essex
    Posts
    6

    Question Unanswered: How can I create a list of users permissions daily

    I need to be able to set up a table listing users permissions, this needs to be run daily and then notify me of any changes without using the auditing or profiler software.


    Any ideas??

  2. #2
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524
    Using your own script, check the syspermissions table(s). Start this job using at or DTS
    F. Celaia
    DBA Sybase/DB2/Oracle/MS-SQL

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Here's a script I used a while back:
    Attached Files Attached Files
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  4. #4
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    Why don't you just set up Profiler or a trace to capture Audit Permission events? It's a good thing to have if you ever get audited anyway.
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

Posting Permissions

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