Club starter kit version 3 c# database issue RSS

• • Reply
  

  daaaon

  Member

  1 Points

  21 Posts

  Club starter kit version 3 c# database issue

  Aug 12, 2010 02:08 AM|LINK

  On SQL server I have set up an account as db owner with password for database.(is this correct?)

   

   

   

• • Reply
  

  nareshguree2...

  Star

  11118 Points

  1997 Posts

  Re: Club starter kit version 3 c# database issue

  Aug 12, 2010 03:46 AM|LINK

  means only Administrator or db owner can access this database.

  if you want to access it, no need to do so. for security point of view, you have done right.

  
  

• • Reply
  

  daaaon

  Member

  1 Points

  21 Posts

  Re: Club starter kit version 3 c# database issue

  Aug 13, 2010 12:59 AM|LINK

  since this is a club web site with login, is this still correct? 

• • Reply
  

  ScottV.

  Member

  50 Points

  15 Posts

  Re: Club starter kit version 3 c# database issue

  Aug 25, 2010 07:41 AM|LINK

  Depends on what exactly you are trying to do. Based upon the small amt of info you provided in your question, here's what I'd do:

  1. create an application login for the application.

  2. GRANT CONNECT permissions to the database to that login

  3. GRANT <whatever> permissions within that database to the login

  This way the application's not using the sa account to do it's business.

  Regards,

  Scott