How do I secure sensitive info from certain users?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Matt_VA - 06 Apr 2006 14:31 GMT

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.

Reply to this Message

Ben Walters - 10 Apr 2006 00:16 GMT

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

> 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
[quoted text clipped - 4 lines]
> I need a way to allow both to run queries, but only the super user type
> should be able to access multiples.

Reply to this Message

Mei Yoong - 13 Apr 2006 07:21 GMT

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

> Matt
> One option here is to use the "User Roles" Functionalty within the InfoPath
[quoted text clipped - 17 lines]
> > I need a way to allow both to run queries, but only the super user type
> > should be able to access multiples.

Reply to this Message