Create user and add to role / schema
Posted on 2009-04-22
I have a SQL Server 2005 database. 100 tables or so which i am right now accessing using the sa login, as this is just dev at the moment i have not worried too much about that.
I have 5 different client applications in the field, the only way people access the server data. I want to make 5 different logins, one for each application. I guess a schema would be the way to go, or a role in a schema?
As you can tell i am new to the security side of logins and have no idea where to start. Do i do it with the GUI, or T-SQL (either way i am comfortable). How do i set the permissions on each table.
As much of a step by step tutorial would be great. I am not using Windows groups or accounts, strictly sql logins.