Unanswered: Securing a single db w/multiple function users?
I need to secure a single database that has multiple users with different functions. Some can update, some read only, etc. I've been through several iterations of the security wizard but each time I set up security, it forces a login no matter what database I'm accessing.
Is there a straightforward way to set up user level security that would only prompt a password when a particular database is opened and not come into play for other databases?