Fetch users,logins and permissions and update the same
- by user1490099
Can any one please help me by giving a query or an idea which helps me?
I am looking for a query which returns the users and logins in a sql server 2008 r2 instance.
If some one has added/updated a user/permissions in next day- if we run a script it should revert all the changes to the previous day status.
Let me give you an example
On Wednesday the database security is fine
On Thursday someone goes into the SQL instance and changes several database user security settings. This creates lots of problems.
On Wednesday if we run a script on the SQL instance and it should reset the database user security back to what it was on Wednesday.
Someone please help me in this regard, Its very urgent..............Please..........