Keeping log

• Lionel2007

  Old Hand

  Points: 366

  More actions

  February 26, 2008 at 8:41 am

  #76912

  Hi,

  I am a dba and I need to keep a log of when a manager asks me to give database access to a programmer.

  Is there anything in place that exists? Something like an Excel spreadsheet or maybe a command that can be run to give me those details.

  Any thoughts or articles would help!

  Thanks.

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  February 26, 2008 at 9:59 am

  #782082

  If I understand your question clearly, you may try the following code

  SELECT name, createdate, updatedate from master..syslogins

• Joseph-465703

  SSCrazy

  Points: 2122

  More actions

  February 26, 2008 at 7:09 pm

  #782326

  can you try to play around with following ones :

  select * from sysusers

  select * from syspermissions

• Sugesh Kumar

  One Orange Chip

  Points: 27311

  More actions

  February 28, 2008 at 5:29 pm

  #783539

  Use the query in the link below and store the result in a excel file

  http://www.sql-articles.com/index.php?page=Scripts/permission_list.php

  Cheers,
  Sugeshkumar Rajendran
  SQL Server MVP
  http://sugeshkr.blogspot.com