Prevent field data changes based on user secuity

[MikeData]

How to allow changes on a field based on user security. lets say only Mgrs can change the data, all may see it,

[MikeData]

I can make the field read only.. Then create an exact form that only Mgr can access and leave that field normal.
That is a very long way. hope there is a better way

[CharlesParker]

not sure in v11 anymore...seems like it should be fairly easy - hopefully someone else still using it will chime in to help

[MikeData]

Thanks, Is it possible in V12?

[madtowng]

Hi Mike,

You don't mention if you're using a grid or an UX, but the grid absolutely gives you those options.

Gregg
2022-08-16_14-51-41.png

[Ronald Anusiewicz]

USER_NAME() returns the name of the current logged on user. Requires that the database be password protected.
USER_GROUPS() creates a CR-LF delimited character string list that lists the groups that the current user is a member of. Requires that the database be password protected.
You can test to see if the user is a member of the manager group,

Assuming you are talking about a form: From Dr. Peter Wayne's book, in the CanChange event, Deny permission to change a record.

if user<>"Mgrs" then
cancel()
end if

[Ted Giles]

Mike, I tend to have different levels of access and update options;
View (Guest)
User (Operational)
Super User ( CRUD options)
Admin(Full control)

Login decides what the person can do and the options are easily set in the Security part of Alpha.

If you would like an example, just post back.

[MikeData]

Thanks for the responses...
.Gregg, my issue is in desktop.. So that sample can not help me.
Ronald you are correct and I use that control on certain areas..
Ted, you are also correct, but in this case I am trying a single field in a form, that all security level have access.
There is one field, that every one can see, but I want to restrict access to it and access to change to only the Mgr people.
As I said I can do it by having a dup form with Mgr rights, accessible via a hot spot near the field.
I was hoping to control the field.
I also tried to make the field inactive upon entry, and again by hot spot activate it. Not so effective,

[Ted Giles]

Put this in the FieldEvent "On Arrive" for the form

if(user_name()<> "guest",topparent:Data.disable(),topparent:Data.enable())

In my example, "guest" is the user group, Data is the field I want to restrict access to.

Only Guest can update the data, but it it at a simple level. You may need to disable the Edit Pencil as well.

[Ronald Anusiewicz]

From Dr. Wayne's book, field object events on a form.
CanArrive, Deny permission to land on a field. This is the same as disabling a field in form design, but it is programmatic control.

dim global user as c
if user<>"supervisor" then
cancel()
end if

[Ted Giles]

Neat solution Ron. Much more elegant.
You could use this as a way of restricting lots of fields all over the database if you had a "tick list" of the ones you wanted to lock down.