Well this isn’t entirely true. We could allow a SQL login to start and monitor SQL activity using the SQL Profiler and yet keeping the read only access to the SQL schemas. Follow these steps to achieve this:
1. Connect to the SQL Server and expand the Security->Logins node
![image image](http://lh3.googleusercontent.com/-d9XyyvX5WmI/ViITNuiHzvI/AAAAAAAADVg/fZa978gJZLY/image_thumb%25255B5%25255D.png?imgmax=800)
2. Right click the desired login and go to ‘Properties’ from the context menu
![image image](http://lh3.googleusercontent.com/-dcARu88kq3U/ViITPPpHVbI/AAAAAAAADVw/Cn4qh1FQoIQ/image_thumb%25255B7%25255D.png?imgmax=800)
3. Go to the ‘Securables’ tab and check/tick the Grant checkbox on ‘Alter Trace’. And click ok to save the details.
![image image](http://lh3.googleusercontent.com/-JRopkydTrMY/ViITRODM4wI/AAAAAAAADWA/QiBbJqB0z2M/image_thumb%25255B15%25255D.png?imgmax=800)
Now you can run the profiler and monitor details using that SQL Login.
![image image](http://lh3.googleusercontent.com/-TjAkpr5KhOY/ViITSmdRVHI/AAAAAAAADWQ/hQI53eYr-E0/image_thumb%25255B17%25255D.png?imgmax=800)
![image image](http://lh3.googleusercontent.com/-z5S7b45OSlc/ViIUBjfAPuI/AAAAAAAADWw/BTXlG9idk6M/image_thumb%25255B22%25255D.png?imgmax=800)
No comments:
Post a Comment