RE: Why do they not listen? – SQLServerCentral

SSC Guru

Points: 1003863

September 30, 2014 at 7:41 am

GilaMonster (9/30/2014)
Eric M Russell (9/29/2014)
Upgrading to the next release of SQL Server offers an excellent pretext for removing unneeded permissions from app developers.
"I'm so sorry, I know it a pain in the a$$, but under SQL Server 20xx a login can't drop/recreate objects unless we make them database owner or sysadmin. It's a new default feature intended to tighten security and prevent SQL injection attacks. Do we really want to operate under a non-standard security configuration? It's best just to leave it as is and let the DBA execute all the deployments."
Because lying to management is such a great way to get them to trust you....

+Infinity.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)