Implement Database Warehouse Authentication

This mode of authentication identifies users by means of a login ID and password stored in the data warehouse database. The RDBMS is the authentication authority and verifies that the login ID and password are valid. Each report is executed on the RDBMS under the RDBMS account of the user who submitted the report from the MicroStrategy system. Users log in to the MicroStrategy system with their RDBMS login and password, and each MicroStrategy user is linked to an RDBMS account.

Use database warehouse authentication if you want the data warehouse RDBMS to be the authority for identifying users and you do not want to maintain user credentials in Intelligence Server as well as the RDBMS. You can also use this configuration if you need to keep an audit trail at the RDBMS level for each query executed by each individual user.

If you use database authentication, for security reasons MicroStrategy recommends that you use the setting Create caches per database login. This ensures that users who execute their reports using different database login IDs cannot use the same cache. You can set this in the Project Configuration Editor in the Caching: Result Caches: Creation category.