Is it possible to use Sql Server 'Roles' ?

M

Me

I would like to make use of Sql Server Database 'Roles' to control access
form's data entry.

I have a form comprising of 3 subforms. There are two groups of people -
admin, dataentryusers

Admin should have the ability to add/modify/delete the entire form.
DataentryUsers should be able to only add records to one of the subform (out
of 3 that the form contains).

Can someone point me to documentation or give me ideas how to do it?

Thank you very much,
-Me
 
Top