Hi,

I need some help pls. Ive been using MS Access as a database and when I needed different right I used to create functions that allows different users to do different things in an application.

For example I need 3 different user types or profiles whatever they're called

1. user to input in certain data.

2. User to do some searches with a read only on data

3. Administrator who inputs in data different from user 1. and does some searches also.


What I need to know is how to handle this is SQL SERVER. Do I set the provileges from within the database or do I use functions and CASE to identify the user.

this is my first attempt on the SQL SERVER. I appreciate all advice on this.

And many thanks