Good security model RRS feed

  • Question

  • Are there any good links to read on how best to create security models on our databases ? Currently, its all over the place.. from groups having access to a few tables to all tables, named logins on some tables, sql accounts,etc.. Some of our servers have like 100+ logins created.. Is there a good way to create accounts? I'd like to create roles... just looking for some advise..

    Also, how best is it to encrypt data ?

    Tuesday, September 27, 2011 2:18 PM