Creating a formula to directly change a User's "Model Role" as well as read/write permissions

I have created and set up Model Roles, Selective Access, Content Access, Permissions and a defining value applied on the lowest level of the list heirarchy for what I would like security permissions to be.

I have 4 levels of security with the highest being Full Access, and the lowest being No Access. The inbetween levels have partial acccess that are heirarchial (Eg. If you have permissions for lvl 2, you have full access to lvl 3 as well).

I want to directly effect what the user's Model Role is, and the read/write permissions on the User page.

Is there a way to do this, and if so, how?

Accepted answers

PaulRitner

Oh, sorry... Emily Litella moment...

You could use (module based) Dynamic Cell Access to control list access, but there is no way to change the role (or any of the physical settings within the User List via formula alone).

Because the role setting impacts Contents, Landing Dashboard, as well as Module, Action, and List Access... the only way to alter that would be to physically change the role setting (in the User List).

You're out of luck on this one.

Cheers!

Paul

All comments

PaulRitner

Hello,

Are you asking for a way to load security settings in one of the following ways?:

Load from a CSV into the User List
Load from a module into the User List

Either way is possible and usually not difficult. The key is thorough unit testing!

You will see the Import option on the User List.

Paul

obriegr

Paul,

Module to the User List.

Import from another model (using a process), causing a formula in the module that is being loaded into to remove/add read/write permissions and change the users role from a pre-defined assocaited object/number.

Essentially, if I load a file that says User XXX@XXX.com has 1 permissions, and then the permissions in the model change, because of formulas in the module that is loaded. User XXX@XXX.com now has role = 1, read/write privilages associated with role 1.

Thank you for your reply.

PaulRitner

I'm not completely following you, but consider the following:

We can use modules to define user level access (including model role) in a variety of ways, and then bulk load those settings into the User List.
These has to be a line item in the module you are loading into the user list that corresponds to the user's email address.
There can be multiple rows per user (for selective access), and the last row that has Model Role will become the setting for model role.

The rest is just getting the load format correct.

The basic format is: UserID (Email), and then whatever user list properties you want to load. (I use the term "properties", but its really model role and selective access columns.)

Does this make sense?

Paul

obriegr

@PaulRitner,

How do I directly effect the "Users" portion on the Model Settings?

Specifically the colomn termed "Model Role"?

I can extrabilate into changing each one of the read or write colomns as necessary.

For example, if I have the module utilize "Users" in the "Applies To" colomn in the Modules page of the Model Settings, what would be the command to set a user (or all users) theoretically to Full Access or No Access, in the "Model Role" colomn.

Thank you for your quick reply.

PaulRitner

Hi,

The user role would be loaded as a Text value, but might also be a list value (i.e. a list of available roles that you can use as a drop-down or reference in if-then logic, etc)

How you would determine what role to load is another question, but once you know which role value to load, its a straight foward as navigating to the user list and importing....the resulting import defintion can be tied to a process and/or button.

obriegr

I am asking if there is another option aside from importing to directly change the Users. Specifically using a formula in a module.

PaulRitner

Oh, sorry... Emily Litella moment...

You could use (module based) Dynamic Cell Access to control list access, but there is no way to change the role (or any of the physical settings within the User List via formula alone).

You're out of luck on this one.

Cheers!

Paul

obriegr

Figures.

Thank you for all of your help!

Quick Links

Can you help?

Unanswered questions

Add list members to a selective access list
Hi, I am working on a solution where the User should only have access to write/edit the list members that they add from an Action on the frontend. This action adds another list member to a selective access list. The problem is, in order to run the action, you need access to the entire list, so you would see all list…
Dimensionality Issue
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
Formula to return Connection details...
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?