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 again instances you have the more mingled that task. In this presentation I'll quota a method using PowerShell and TSQL that be able to be used to capture permissions from all of your SQL instances and oppression them into a centralized location. We'll strange to say take it a step further by auditing those permissions so that we be able to quickly and easily identify any that efficacy have changed.
No comments:
Post a Comment