conditional privileges

[hassam36]

Hello

I want to set conditional privileges in certain tables/forms where each user will only have access to certain records (multiple records).

I have stored the values of the accessable records in a global array for each user. However, I am not sure how to access all the values in the array in the 'custom privileges' calculation dialogue box and set the appropriate field (in this instance primary key) equal to each one separately.

I'm not sure if this is clear or not, but, if so, any ideas?

[Steven H. Blackwell]

Well, sorry to say, it's not clear, at least not to me. If what you're wanting to accomplish is to limit access to records to certain suers, all of whom have the same privileges, then you'll want to use Record Level Access.

In the Privilege Set definitions under the access to tables section, set a calculation that provides the test for a user to meet. For example, a user can see on;y those records he or she created.

Steven

[Genx]

A warning on a different note here -- Don't use globals for this

i.e. you can have a table somewhere storing individual records for each user and then you set the global when you open the file -- but do not make the assumption that your global will retain it's value when you close a file.

[Steven H. Blackwell]

Who said anything about a global? I didn't say that.

Steven

[Genx]

I have stored the values of the accessable records in a global array for each user.

No... you didn't and I wouldn't have mentioned it if you did.