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.
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 could be assigned the same role twice: once through the auto-load job an once manually.
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.
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.
