I am creating a new sql server, on a server, and am not sure how to allow other users to access the database(s) on it.
we use the windows domain authentication, so each user has a user name and such. Do i need to create a new user for each person that wants to use the database? Or can I create a user on the server and specify which people are that type of user?
general user, power user, admin user, etc.
Or does each person need a login or user entered into the server?