• Please please please read the documentation, take a course or at least sit down and read a book! Security is the single most important aspect of data management and if you are unaware of how to assign rights, permissions and roles through the Management Studio then you have the most enormous gap in your knowledge and whats more, I would suspect a dangerous lack of ability to secure your database!

    Don't take that the wrong way but it takes very little to get security wrong......