EXECUTE AS sa

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737487

  More actions

  April 26, 2016 at 10:14 pm

  #77476

  Comments posted to this topic are about the item EXECUTE AS sa

• Revenant

  SSC-Forever

  Points: 42467

  More actions

  April 27, 2016 at 9:05 am

  #1874973

  Not many attempts... Interesting.

  Thanks, Steve!

  edit: typo

• George Vobr

  SSChampion

  Points: 10050

  More actions

  April 27, 2016 at 9:35 am

  #1874985

  Thanks for this question Steve. Today I had to do with the question of a hard time, really dangerous.:-) Eventually helped me this article, which confirms that it is dangerous:

  http://dbaspot.com/ms-sqlserver/231843-how-grant-impersonate-dbo-permissions.html

• April 27, 2016 at 12:53 pm

  This was removed by the editor as SPAM

• Ed Wagner

  SSC Guru

  Points: 287026

  More actions

  April 28, 2016 at 5:22 am

  #1875196

  I don't like granting impersonate, but the EXECUTE AS comes in very handy sometimes.

  Tally Tables - Performance Personified
  String Splitting with True Performance
  Best practices on how to ask questions