Privileges / Restrict access to found records

[fmlondon]

Hello

This is my first post as I'm really stuck this time - although I've found loads of useful advice here in the last year!

I've got a relatively complex DB but am self-taught so I'm sure it doesn't follow 'normal' design procedure!

Basically, I want to restrict access to certain found sets of data based on users privilege set - which I know how to test and have a startup script that gets this data into variables.

My problem is if I do 'find' script steps - it gives the correct data, but still leaves the user the option to 'show all' which I don;t want. If i restrict the interface, it also takes away too much other functionality. They access through IWP and FMnet so same thing with the web interface - it also has 'show all'.

I assume this can be done in relational links, but I'm confused - nothing I've tried works, and it seems like I then have to make a completely new set of layouts per privilege set - just so it points to the right tables?

Am I better off trying to sort out the interfaces, or restricting the data more securely?

Thanks for any help (and understanding!)

[Peter (duksis3)]

Try method I have post earlier:

Post#345409 and Post#338523

[Matthew F]

You might want to hide the status area from the users and recreate its functionality with customized buttons and calculated fields. For your example, you'd want a button that goes into find mode and adds the Users name to the find request so they only end up seeing records to which they have access.

[Steven H. Blackwell]

Welcome to FM Forums.

You don't do this with scripts or with the User Interface. You do it with the Privilege Sets. Search the Forum for Record Level Access.

Steven