sqlserver 2005 database security different between database role and application role

• ganeshanmsc

  SSC Veteran

  Points: 226

  More actions

  July 10, 2010 at 3:13 pm

  #235091

  sqlserver 2005 database security different between database role and application role

• SQLRNNR

  SSC Guru

  Points: 281334

  More actions

  July 10, 2010 at 4:16 pm

  #1191174

  This article will lay it all out for you:

  http://www.simple-talk.com/sql/database-administration/sql-server-security-cribsheet/

  Jason...AKA CirqueDeSQLeil
  _______________________________________________
  I have given a name to my pain...MCM SQL Server, MVP
  SQL RNNR
  Posting Performance Based Questions - Gail Shaw[/url]
  Learn Extended Events

• vincehorst

  Valued Member

  Points: 50

  More actions

  August 2, 2013 at 3:54 pm

  #1638375

  This article is a much better summary IMO:

  http://voiceofthedba.wordpress.com/2012/11/26/how-application-roles-work-in-sql-server/