Privileges and user group

[gaby_h]

I have followed the instructions in the help file and created groups of users like Admin, Supervisor, Agents. My problem is that there are only 2 types of privileges for Tables/Forms/Reports..: Grant and Deny and nothing in between. For expl at table level for Change Records, it is either granted or denied. Suppose I want to grant the change of records to Agents only if record date is less than 3 days old or some other condition like Amount is less than $500 and Supervisor the privilege to change records if amount is less that $3,000 and change is denied if record is older than, say, 10 days. How can I go about it?

[Tom Cone Jr]

Re: Privileges and user group

If you require the user to push a button to change a record the button's onPush event could run a script that determines if edits by the current user are ok. In other words, instead of blocking edits to a table by group, you can get the granularity you need by blocking edits at the form level.

[gaby_h]

Re: Privileges and user group

Hi Tom:

you can get the granularity you need by blocking edits at the form level.

That would be great. But here too, when I go to From Properties, under Restrictions, it is Change Record or not. I can't find a feature that allow more flexibility.

[Tom Cone Jr]

Re: Privileges and user group

I'm sorry if my earlier post misled you. I wasnt' speaking of form properties. I was trying to describe a button that runs a custom script. That script determines the identity of the current user, checks to see which groups they belong to, then checks to see if other "allow edits" criteria are present. If all is good, then the form's restriction against edits is lifted. If not the user gets an explanatory message. When the edited record is saved, the restriction against edits is re-imposed.

If you're looking for a single button solution to your custom requirements you're going to be disappointed. However, Alpha has the necessary tools to permit you to build a custom solution easily.

[Mike Wilson]

Re: Privileges and user group

Gaby,
Added to what Tom wrote, you are evaluating the values in a record and comparing the values against a pre-established matrix to set the security level that is or is not allowed access to edits/changes/deletes. This is an algorhythm that is developer-established and is beyond the turnkey single parameter security provided with the grouping system in A5. What you are describing, to me, will require either a script with many if-end if or selection-case-end selection statements, or a separate table having the field values that are allowed for a given security class with a lookup() script that uses the form field values within the filter for that security table. It's doable. It just matters on the complexity of the matrix that you envision as to which approach you desire to use.

[gaby_h]

Re: Privileges and user group

Tom: I see now, thanks for taking the time to clarify things for me.

Mike:

Added to what Tom wrote, you are evaluating the values in a record and comparing the values against a pre-established matrix to set the security level that is or is not allowed access to edits/changes/deletes.

Is there an example of such matrix that I can study? I searched this board but could not come up with something similar. If there is no example available , I would appreciate it very much if you could indicate the steps/functions to achieve this. Thanks in advance.

[MikeC]

Re: Privileges and user group

Hi Gaby,

Is there an example of such matrix that I can study? I searched this board but could not come up with something similar. If there is no example available

I am not certain that the attached samples are exactly what you need but might help a bit--they are samples that have been posted here on the messageboard that I saved in my help file......they all deal with login and security. There was a fairly extensive post on this also I remember but would have to search again to find it--

[gaby_h]

Re: Privileges and user group

Thanks Mike, much appreciated, I'll study them.

[gaby_h]

Re: Privileges and user group

Hi Mike:
I can't open any of them, they are all password protected. I was hoping to find a txt file with the password with the zipped files.

[Tbaker]

Re: Privileges and user group

Gaby

One of the logon scripts that Mike shows in his post is one that I posted awhile ago. He shows it as the one with TomB after it.

The user name is admin
the password is alpha

Tom B

[MikeC]

Re: Privileges and user group

Thanks Tom! Obviously I have not tried to open them before--I will try and search down the logon and passwords for the other 2--maybe Tom Cone can remember which of his samples this is as I did rename the sample which makes it a bit more difficult.

Just got the Login sample one---for Charlie Crimmel the password is crimmel