This article demonstrates one method to grant READ access to all DBs while still keeping the environment secure & hitting that chord of doing it efficiently.
How to Easily Grant Permissions to all Databases
Tag: Audit
Server-Level Roles – Back to Basics
In this article, I have shown how to use the power of custom server roles to help reduce your administration time. The custom security role is like using a security group to grant a bunch of people the same sets of permissions.
Automate Credit Card Audits
In this article, I have shown how to use the power of automation to help identify the risk of having card data stored in the database. Identifying this risk is essential to helping maintain the trust of your clientele and protecting your companies most valuable asset – the data!
Audit Logons with Extended Events
This article shows how to audit the logon events for SQL Server 2012 and beyond through the use of XEvents.
When Too Much is Not a Good Thing
Explore how to avoid unwanted results that oft occur due to lack of attention to detail, use of internet examples, misunderstanding of the requirements; and always from granting way too much access.
Who needs data access? Not You!
With a little planning and care, we can find various ways to fulfill user requests without compromising the environment.
Life Support 2008 – Audit Logons
Planning to upgrade/migrate requires a fair amount of prep work. Some of that prep work involves auditing your server for any users that may still be using the instance.
Public Role Permissions – Back to Basics
If you are being serious in your role, then the amount of times you grant permissions to the public role should either be a) never, b) when you want to have a data breach, or c) you are testing in a sandbox to improve your skills.
T-SQL Tuesday #108: New Horizons Beyond SQL Server
There comes a point in one’s career when a change is requisite. Big or small there always seems to be a tipping point that mandates some sort of change. Maybe the change is an entirely new career field. Maybe the change is adapting to the ever improving features of a specific software or product. Maybe, that change means learning a tangential technology.
Audit Database Offline Events
Knowing when an event occurred within the database environment is a very important thing. Being able to act quickly when certain events occur is equally as important. Sometimes, we may not find out about an event for a few days or weeks and then we are asked to figure out the who, when, why and how of the event. Hopefully there was enough foresight in place to plan for such a request to travel back in time.