Financial Analyzer Database Security

Shared Database

Access to a Financial Analyzer shared database ofas.db is controlled through the PERMIT_READ and PERMIT_WRITE functions of the Express Server PERMIT command.

To attach the shared database in read/write mode the connection to Express Server must be made using an operating system username that is associated with the Financial Analyzer Administrator workstation user for that shared database. Once attached in read/write mode, all the objects in the database are available to the user.

When you attach the shared database read-only the connection to Express Server must be made using an operating system username associated with a valid Financial Analyzer user who is defined by the Administrator for that shared database. The user will only be able to access the dimensions, dimension values, financial data items, hierarchies, and attributes that have been distributed to that Financial Analyzer user connected with that operating system username. If the operating system username is associated with more than one Financial Analyzer user then the database objects available to the user will be those distributed to the first instance of that Financial Analyzer user in the list of users.

Workstation personal database

Access to a workstation's personal database is controlled by the operating system username entered in the Connect to EXPRESS Session dialog box when starting Financial Analyzer. The operating system username must be associated with a Financial Analyzer user.

For detailed information about associating operating system usernames with Financial Analyzer users, refer to the topic "Creating Users" in the Financial Analyzer Help system.