SQL PASS Summit 2011 - Enterprise Database Administration and Deployment
English | WMV3 | 640x480 | 15fps 241kbps | WMA 32kbps | 7.14GB
Genre: Video Training
As a DBA it be possible to be a challenge to know who has permissions to that which SQL instances and what objects. The in addition instances you have the more complicated that task. In this presentation I'll dividend a method using PowerShell and TSQL that be possible to be used to capture permissions from every one of of your SQL instances and weight them into a centralized location. We'll equable take it a step further through auditing those permissions so that we be able to quickly and easily identify any that main have changed.
No comments:
Post a Comment