Auto-Load Roles

Administrative and/or highly technical users can now create and manage roles where users can be set to auto-load based on a SQL query.

The form is available in each application under: Administration -> Access -> Auto-load Roles.

The form can be used to create and manage your auto-loading roles assignments based on a pre-defined query.

When saving on this form, all users returned by the query at that moment will immediately be granted the role(s). Then a nightly job will re-run the query to keep the list of granted users current.

Notes and Technical Tips:

1. Any users who have been manually granted the role outside of the auto-load function will not be affected by the auto-load process. In other words, users who have been assigned a role manually are not eligible to have it auto-loaded as well.

2. Users must exist in the FASTPORTAL.vwAllUsers (in other words, be valid FAST users who can log in and receive roles under normal circumstances) to be successfully auto-loaded.

3. The SQL query will be executed under the FASTPORTAL schema, so be sure that any required grants, synonyms or database links are in place before saving.

For additional assistance, please contact Customer Support.

Related topics

• Adding New Roles

• Adding Roles to Menus

• Adding Roles to Users

• Setting Roles to Expire