What I was thinking, was to set up application roles, each permitting access to a different set of stored procedures and/or views in a particular database. Simplified examples would...

I guess, ultimately, what I want to do is set up various Application Roles and assign groups of Windows-authenticated users to these roles. I don't know how to do this...

Thanks for the responses, much appreciated.

In this situation, I am using the SQL Server Developer edition installed on my own PC, which uses my own standard login/username and Windows authentication as the account under which...