Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
6
Newest
 Scholar
Impact
~2k people reached

  • 0 posts edited
  • 0 helpful flags
  • 3 votes cast
Aug
11
awarded  Scholar
Aug
11
comment Temporary permissions for DDL
@AaronBertrand Fair enough, point taken.
Aug
11
accepted Temporary permissions for DDL
Aug
11
comment Temporary permissions for DDL
It's nice to be able to open and review DDL scripts and not worry about a stray F5 in the wrong window will have catastrophic effects. If the error rate of a human is a mistake every 5 days, but you only have elevated permissions in order for that mistake to actually have an impact 10 minutes out of that time frame, you've decreased the likely hood of an actual error occurring to being the probability that the mistake lines up with that timeframe.
Aug
11
comment Temporary permissions for DDL
@AaronBertrand "that too can happen even when you previously elevated your own privileges" If properly applied you shouldn't be leaving yourself in an elevated state after you've performed the necessary task. Same reason switches in mission critical systems have additional cover plates that have to be toggled before they are actice. Yes mistakes can still happen while elevated, but it greatly reduces the chance of that happening by limiting the timeframes in which they can occur. It's a pretty well established best practice. The discussion is how to apply it to SQL server.
Aug
11
comment Temporary permissions for DDL
@AaronBertrand Obviously the DDL has to be right. I am not talking about validating correctness. For the same reason you shouldn't have root admin access on an operating system by default, except only when/as needed, there is no reason for me to have DDL write permissions at all times except only when/as needed.
Aug
11
asked Temporary permissions for DDL
Dec
23
awarded  Popular Question
Sep
24
awarded  Autobiographer
Jan
3
awarded  Teacher
Jan
2
answered Advantages of Database Snapshot
Nov
10
awarded  Supporter
Sep
12
awarded  Student
Sep
12
asked How do aggregations work in SSAS?