When Essbase is in EPM System security mode, some security information is stored by Shared Services and external user directories, and some security information is stored in the Essbase security file (essbase.sec).
The following information is stored by Shared Services or by the external user directories:
Users
Groups
Passwords
User and group role information for applications
The following information is stored in essbase.sec:
Calculation script access
Filter access
Application access type
Application and database properties, including substitution variables and DISKVOLUMES settings (block storage databases only)
When Essbase is in native security mode, all information about users, groups, passwords, permissions, filters, applications, databases, and their corresponding directories is stored in essbase.sec.
The essbase.sec file is located in the ARBORPATH/bin directory.
The contents of the essbase.sec file is encrypted; however, the contents can be exported to a readable, text file format, which is useful for review purposes. When exporting essbase.sec, follow your company’s security procedures to ensure the integrity of the data. See Exporting the Security File.