Login history

• rj529

  Ten Centuries

  Points: 1194

  More actions

  March 13, 2013 at 5:11 am

  #269779

  Hi Friends,

  Let us consider I have a login ABC & I have given db_reader access for XYZ Database. But now that particular login has db_owner permission. Is there any way to find when that user ABC has got the db_owner permission.

  Thanks in advance

• Ant-Green

  SSC Guru

  Points: 113445

  More actions

  March 13, 2013 at 5:22 am

  #1596434

  Unless you have custom auditing in place you wont be able to find when it happened.

  You could try the default trace but depending on how busy the server is will depend if the event is still in the trace.