Solved

SQL Server user crentails has been changed automatically

Posted on 2014-10-24
4
20 Views
Last Modified: 2016-06-15
Hi All,

I have across the situation  SQL Sever user credentials has been changed from DBO to read/write.
Now how to find out when those credentials has changed and who changed.

Please body can suggest me how to find out ?
0
Comment
Question by:GK GK
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 34

Expert Comment

by:ste5an
ID: 40401280
D'oh? Are we talking about credentials (logins, user, groups) or permissions (roles, single permissions)?
0
 
LVL 50

Accepted Solution

by:
Vitor Montalvão earned 500 total points
ID: 40401714
Now how to find out when those credentials has changed and who changed.
If there' s no active Audit then you can't find the information that you want.
0
 

Author Comment

by:GK GK
ID: 40416836
Hi Victory,

Thanks,we don't  have audit active.
0

Featured Post

Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question