FM11 : Get (AccountPrivilegeSetName) vs Get (CurrentPrivilegeSetName)

[El_Pablo]

Hi,

I read the help from FM documentation, but it is not clear. What is the difference between the two functions?

Thanks

[IdealData]

The way I read it means there is no difference - the function has simply been renamed.

[Vaughan]

Indeed there is a difference.

An example: a user opens a database with an account and password that is assigned to the "[Read Only]" privilege set. The Get( AccountPrivilegeSetName ) will return "[Read Only]". The Get( CurrentPrivilegeSetName ) will also return "[Read Only]"

However let's say the user now runs a script that is set to run with full privileges. While this script is running the Get( AccountPrivilegeSetName ) function will return "[Read Only]" but the Get( CurrentPrivilegeSetName ) will return "[Full Access]".

In FMP 10 and earlier, the developer had to be careful with the Get( PrivilegeSetName ) function because it would return "[Full Access]" if it was invoked while a script was running with full access. The new function (and renaming of the old) seeks to resolve this issue.

From the function reference:

Get(AccountPrivilegeSetName) The name of the privilege set that is being used by the account used to open the database file.

Get(CurrentPrivilegeSetName): The name of the privilege set that is being used to evaluate this calculation in the database.

[IdealData]

Thanks for the correction Vaughan - I didn't try it out yet.

[El_Pablo]

thanks for clarifying this point