How do I secure sensitive info from certain users?

[Matt_VA]

I need to create a form that is going to be submitting to an SQL database. I
will have two seperate types of users. One type will need only to submit and
edit their own data. They will not need to be able to have access to anyone
else's. The second group will need to be able to query on any user by
sensitive data.

I need a way to allow both to run queries, but only the super user type
should be able to access multiples.

 

[Ben Walters]

Matt
One option here is to use the "User Roles" Functionalty within the InfoPath
designer, if you go to Tools>User Roles you can create 2 user role groups
that point to Active directory , You can then use these roles to determine
what a user can and can't see. Now I'm not sure exactly how your form is set
up but on approach might be to have one View for the Administrator type
users, and a second View for the lower users.

If you need more detail on this let me know

Cheers
Ben Walters

 

[Mei Yoong]

hi ben,

i have similar doubts as matt, my question is are we able to set user roles
control to limit the access for sub infopath forms? within my infopath forms
i have many sub forms/views, am i able to set different control to different
group of users to access my sub form? The group of user to my subform is
different from my main form

thanks