Jump to content

Record level access for multiple users


This topic is 7578 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I have a query regarding record level access on the web. I have a database in which I would like selected records open to browsing by all users, while the remaining records are viewable only by around 500 users, each with unique IDs and passwords (in the Web Security databases). Any ideas on how this can be achieved?

Link to comment
Share on other sites

selected records open to browsing by all users-

mark those records by use of a field and then use that criteria to fitler them in the serch.

- mark each record (eg. field [VisibleRecord] (1,0) 1- being visible/browsable to all user

OR when a user loggs in

- mark each user record as "guest" or "admin" or "something"

- use the FMP-IF statement when constructing form for a serach based on either "user rights" or "record visibility"

(eg. [FMP-If: UserLevel.eq. admin]....construct the form

FMP-Else .....

or on the results page exclude/include the records based on "RecordVisible" field

All the best!

Link to comment
Share on other sites

This topic is 7578 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.