title: SQL Server permissions application
body: <p>I have an application where I have a group of users. They use the app UI to view different information within a database. However, there are some information that some users are not allowed to see. So, I was thinking that I could create groups and add the allowed users to these groups. I read about roles in Sql server, but it seems to me that I need to create a login for each user. But, in my app I connect to the database using sa and when the user logins, the app checks the password+username in a "Users" table within the database. So, is there any way I could create these permissions?</p>