Which system tables in SQL server 2008 /SQL server 2012 have the following information:
1. User right/permissions on different databases/tables/sprocs?
2. Database instance configuration like Cost Threshold for parallelism and Max Degree of Parallelism
3. when user rights changed or configuration changed,, how to track when it was changed and who changed it.
I want to know so that I can link the data to our SQL source control and track any changes to rights, permissions and configuration.
Any help is highly appreciated.