How to retrieve the privilege set belonging to a specific account ?
I am working on a script for a stand-alone FM11 database to revert passwords.
My database has 4 privilege sets:
Level 1: [Read Only], FM default set
Level 2 : [Edit Data Only], FM default set
Level 3: Limited Admin, custom privileges, no design privileges
Level 4 : Full Access, FM default set
Only level 3 and 4 shall be allowed to revert passwords. Level 1 and 2 users can only change their own current password.
However, I have to prevent level 3 users from changing the password of level 4 accounts.
Is there a way how to retrieve the privilege set belonging to a specific account (without first creating searchable records with the user accounts and their privileges) ?
Thanks for sharing your knowledge and experience.