SQL Server security setup
Posted on 2015-01-24
I need some instruction to test my security skills (Windows authentication and then creating roles and applying permissions). Although I have installed SQL Server Express 2012 on a local PC with Windows 7 professional, I think I could, for example, create some user account in Windows like:
DatabaseNWadminPerson 'for Northwind
DatabaseWSadminPerson 'for another database I have
Now according some spec, perhaps from you, I could proceed creating all these rolls (map them to users I have created etc.).
To practice my skills and also become familiar with the terminologies, supposing I am hired for admin job, and my boss gives me this written instruction to apply.
Question: Could you help to put together instructions like this for my use?
Or, is it possible somewhere I could find something similar.