You are viewing limited content. For full access, please sign in.

Question

Question

List of tables showing permissions in forms

asked on March 23, 2020

I'm trying to work on conducting a report to demonstrate what users have access to Laserfiche forms business processes. I need to include LFDS groups. If someone could relay which tables in forms has this information it would be much appreciated. 

0 0

Answer

SELECTED ANSWER
replied on March 24, 2020

I'll preface this with: It is HIGHLY discouraged to try and modify any of these values in the database directly. But for read-only reporting purposes only...


cf_users has the user list and IDs
cf_business_processes has the process list and IDs
cf_roles has the roles list and IDs

The mappings between users, business processes and roles occurs in 
cf_users_in_role
cf_user_profile_by_bp

3 0
replied on March 24, 2020 Show version history

Thank you Jared,

 

This is strictly for reporting. This report is to verify who has access to what business process. This would be a similar report as the effect rights that can be generated within the Laserfiche Client except this is specific for forms. 

Does this tie in with LFDS groups?

1 0
replied on March 24, 2020

It's based on the users as they exist in Forms. LFDS groups can be allowed access to Forms, and if you set up process security based on those, it should carry through to the database. 

0 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.